Tracking node properties with AAAR_DataMart

jdias — Mon, 18 Aug 2014 15:45:58 GMT

Hi.At the moment I'm analyzing the AAAR_DataMart and the audit reports built with it and I have a question related to the tracking of the document properties.Is there a way to track the changes of a document property?I already check the actions report and there's a action called UPDATENODEPROPERTIES

Re: Tracking node properties with AAAR_DataMart

fcorti — Mon, 01 Sep 2014 08:55:53 GMT

Hi Joana,

The reply to your question is described directly in the AAAR_DataMart structure documented here: <a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-audit-data-mart/">http://fcorti.com/alfresco-audit-analysis-reporting/aaar-audit-data-mart/</a>

The information about the changed property is not stored actually so you cannot enquiry it.
In the Alfresco audit trail you have this information so, changing the extraction, you could store this information (this change to the extraction is not so easy to develop, but possibile).

The information about who changed is stored in the dm_dim_users connected to dm_fact_actions using the user_id field.

The information about 'when' is stored in the date tables (http://fcorti.com/alfresco-audit-analysis-reporting/aaar-audit-data-mart/aaar-date-dimension/) and time tables (http://fcorti.com/alfresco-audit-analysis-reporting/aaar-audit-data-mart/aaar-time-dimension/).
Using that set of table you can enquiry when in therms of days and hours.

I hope this will help you.
From more informations don't esitate to contact me.

topic Tracking node properties with AAAR_DataMart in Alfresco Archive

Tracking node properties with AAAR_DataMart

Re: Tracking node properties with AAAR_DataMart