topic Re: Auditing in Alfresco in Alfresco Archive

Auditing in Alfresco

jon_williams — Fri, 25 Jul 2008 17:08:41 GMT

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

Re: Auditing in Alfresco

jbarmash — Sat, 26 Jul 2008 16:27:24 GMT

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.

Re: Auditing in Alfresco

jon_williams — Wed, 30 Jul 2008 12:17:03 GMT

Thanks much. That helps.

Re: Auditing in Alfresco

midhun — Sun, 01 Feb 2009 11:05:28 GMT

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

Re: Auditing in Alfresco

mitpatoliya — Wed, 19 Jan 2011 16:55:36 GMT

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.?

Re: Auditing in Alfresco

mohitsi — Tue, 07 Jun 2016 13:03:56 GMT

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?

Re: Auditing in Alfresco

steven_okennedy — Tue, 07 Jun 2016 17:42:58 GMT

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

Re: Auditing in Alfresco

anniehobbs3030 — Wed, 29 Jun 2016 22:25:32 GMT

www.dumpscvvcctracks.wordpress.com

cardingdumpscvvcc.blogspot.co.uk