Tracking node properties with AAAR_DataMart

[jdias]

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. It's possible to know wich property changed, who changed it and when?

Thanks in advance.

[fcorti]

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.