topic Re: How to view the audit trail of a deleted item? in Alfresco Archive

How to view the audit trail of a deleted item?

joechavez — Mon, 23 Jun 2008 15:44:55 GMT

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

Re: How to view the audit trail of a deleted item?

ribz33 — Tue, 24 Jun 2008 15:28:53 GMT

I think its not possible because audittrail save node's uuid in database (see "alf_audit_fact" table in your database )
After you delete node, uuid point to nothing so you are not able to get node properties.

In this case, I'm not sure that audit is best way to do what you want.
Probably you will need to use a rule or a policy to log all node properties in a file when user is deleting node.

I Hope this help you…

Re: How to view the audit trail of a deleted item?

joechavez — Sat, 28 Jun 2008 03:53:19 GMT

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…

Re: How to view the audit trail of a deleted item?

andy — Tue, 19 Aug 2008 15:42:26 GMT

Hi

This is on the improvements list for auditing.

The delete API does not have the parent in the API call - which is what audit records.
This will be fixed up when we update the audit schema to pull out more node references rather than leave then as strings.

Andy