Auditing in Alfresco

[jon_williams]

I'm testing out Alfresco for a very specific need our company has.  We're talking about a handful of users and perhaps 1 workspace.  An important requirement we have is for audit trails.  Specifically I need to be able to track who accesses a document and when.

I've been trying to enable auditing in Alfresco and am getting frustrated with the current documentation.  It seems to assume a much greater familiarity with Alfresco than I currently have.  The page I've been looking at is http://wiki.alfresco.com/wiki/Audit_Configuration.

The question I have is this.  Is there more in depth documentation for auditing in Alfresco?  I don't want theory.  What I want is to not only know how to enable it but to also know how and where that data trail is stored.

I don't mind spending more time on Alfresco but keep in mind I'm only demoing it.  This is a small side project and I can't afford a huge time sink.  So any advice would be appreciated.  Even if it's "walk away".

[jbarmash]

The audit information is stored in the database.  

For me, when I enabled auditing, it would start populating those tables. 

<Audit xmlns="http://www.alfresco.org/model/audit/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
enabled="true" auditInternal="false" mode="all">
‍‍‍

You can also use a presentation template (don't remember the name) that comes with Alfresco to view some of the auditing information - look through the supplied ones and it will be obvious which one.

[jon_williams]

Thanks much.  That helps.

[midhun]

Hi,
The auditing mentioned here is the same as versioning ? or separate audit  function available. In webclient where exactly     we can see the audit details.
Is it possible to call audit details through  web service out side of alfresco. Could you please  tell the datails of that

[mitpatoliya]

Hi midhun,
Auditing is different from versioning.
It is actually out of box functionality available in alfresco which gives you very low level(method) level detail Related to each services of Alfresco.
you can configure it by enabling auditing from audit-services-context.xml.
Then in view details page in custom view action you can attach the show-audit.ftl template.
That's all you are good to go.
You can see the audit details on web-client.

But i am facing the problem with version 3.2r same files work for other versions but not for 3.2r does any body have any idea.?

[mohitsi]

I have successfully added auditing related properties and able to see the logs in alfresco.log and Auditing dashlet(Which I added later) but I am unable to see the auditing related content in database. Can anyone specify in which tables these are getting stored?

[steven_okennedy]

The parts of the schema used for auditing are complicated, but the main tables are alf_audit_app and alf_audit_model for the audit definitions etc and alf_audit_entry for the actual audited entries.  In addition to these tables, the audit_values_id column of the alf_audit_entries table actually maps out to alf_prop_XXXX tables starting with alf_prop_root & alf_prop_link.  These tables then link out to others depedning on the data type of the key/value being stored. It's further complicated by the fact that these alf_prop_xxxx tables are used for more than just audit tables as well

You're often better going for the RESTful web services instead http://docs.alfresco.com/5.1/concepts/audit-rest-api.html

Regards

Steven

[anniehobbs3030]

www.dumpscvvcctracks.wordpress.com

cardingdumpscvvcc.blogspot.co.uk