AAAR to capture Actions for specific site?

cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

AAAR to capture Actions for specific site?

Hi Francesco- I'm able to configure AAAR to Alfresco Community edition 5.1. Currently my repository has 10 sites. The captured audit data is generic to all sites. I wanted Audit to filter for a specific site is that possible? Currently i don't see filters to filter for specific site. Kindly help.

3 Replies
Alfresco Employee

Re: AAAR to capture Actions for specific site?

Hi Bharath,

The data warehouse stores all the data and filtering is possible defining custom views over it.

You're need is not covered by a bundled report or dashboard but you can develop your preferred one, starting from an existing one.

My suggestion is always to start from the SQL query on the AAAR_DataMart schema (understanding the meaning of the tables is straightforward).

A.A.A.R. data marts - Francesco Corti 

Then you can move to define the views: using a report or a dashboard.

A.A.A.R. - Alfresco reports, dashboards by F.Corti 

I hope this will help you.

Active Member

Re: AAAR to capture Actions for specific site?

Reviewing Data mart tables, i think ope_audits has the required information. I will define views basing on this. Thank you. 

Alfresco Employee

Re: AAAR to capture Actions for specific site?

Just to let you know STG_ tables and OPE_ tables are used during the extraction and they contain only a portion of data. Only the DM_ tables are the "real" warehouse.