topic How to view the audit trail of a deleted item? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174447#M127577 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I turned on auditing, and as long as the item is there, I can see its audit trail. The question is, if the item has been deleted, how can I see its audit trail? </SPAN><BR /><BR /><SPAN>I've created a space called "test", checked a document "work.doc" under the space "test", and I can see the create operation in the audit trail of the space "test". Now, as long as the item "work.doc" exists, its audit trail is there. But once it's been deleted, how can I see who did it? After its deletion, the audit trail of its parent space "test" did not record the delete operation. how come?</SPAN><BR /><BR /><SPAN>Thanks for any info.</SPAN><BR /><BR /><SPAN>joe</SPAN></BODY></HTML> Mon, 23 Jun 2008 15:44:55 GMT joechavez 2008-06-23T15:44:55Z How to view the audit trail of a deleted item? https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174447#M127577 Hi,I turned on auditing, and as long as the item is there, I can see its audit trail. The question is, if the item has been deleted, how can I see its audit trail? I've created a space called "test", checked a document "work.doc" under the space "test", and I can see the create operation in the audi Mon, 23 Jun 2008 15:44:55 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174447#M127577 joechavez 2008-06-23T15:44:55Z Re: How to view the audit trail of a deleted item? https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174448#M127578 <HTML><HEAD></HEAD><BODY><SPAN>I think its not possible because audittrail save node's uuid in database (see "alf_audit_fact" table in your database )</SPAN><BR /><SPAN>After you delete node, uuid point to nothing so you are not able to get node properties.</SPAN><BR /><BR /><SPAN>In this case, I'm not sure that audit is best way to do what you want.</SPAN><BR /><SPAN>Probably you will need to use a rule or a policy to log all node properties in a file when user is deleting node.</SPAN><BR /><BR /><SPAN>I Hope this help you…</SPAN></BODY></HTML> Tue, 24 Jun 2008 15:28:53 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174448#M127578 ribz33 2008-06-24T15:28:53Z Re: How to view the audit trail of a deleted item? https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174449#M127579 <HTML><HEAD></HEAD><BODY><SPAN>whoa, that makes the whole functionality of audit trail a lot less useful then. I checked in the tables, the log items are there, but there's no way to get them out or generate a report, unless rolling your own…</SPAN></BODY></HTML> Sat, 28 Jun 2008 03:53:19 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174449#M127579 joechavez 2008-06-28T03:53:19Z Re: How to view the audit trail of a deleted item? https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174450#M127580 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>This is on the improvements list for auditing.</SPAN><BR /><BR /><SPAN>The delete API does not have the parent in the API call - which is what audit records.</SPAN><BR /><SPAN>This will be fixed up when we update the audit schema to pull out more node references rather than leave then as strings.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Tue, 19 Aug 2008 15:42:26 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-view-the-audit-trail-of-a-deleted-item/m-p/174450#M127580 andy 2008-08-19T15:42:26Z