topic Re: Auditing in Alfresco Archive

Auditing

marco_altieri — Wed, 08 Aug 2012 12:14:57 GMT

Hi,I'm working with the auditing service in Alfresco 3.4.7 EE.Unfortunately, as far as I know, starting from the 3.4 the audit database couldn't be a accessed directly and some useful tables like alf_audit_fact are not available anymore.I'm wondering if someone has already developed something to exp

Re: Auditing

afaust — Wed, 08 Aug 2012 15:52:21 GMT

Hello,

the Audit component was refactored in 3.4 and audit information is now stored in the alf_prop_* tables as far as I know. Accessing the Alfresco DB schema directly is considered bad practice exactly for this reason - the abstraction layer of Alfresco services has remained stable throughout this change.

I am not aware of an export module in the community - depending on the audit application I'd expect that a generic export utility would not be that useful, as audited data might need specific processing if exported to an outside universe.

Regards
Axel

Re: Auditing

marco_altieri — Thu, 16 Aug 2012 13:15:50 GMT

Hi Axel,

thank you for your reply.

Do you think that ti could be feasible to customise the method:

Map<String, Serializable> audit(
            final AuditApplication application,
            Set<String> disabledPaths,
            final Map<String, Serializable> values)

in AuditComponentImpl to store audit data in an external database (BO universe).

Thank you,
Marco

Re: Auditing

afaust — Thu, 16 Aug 2012 15:59:25 GMT

Hello,

I wouldn't do that, as this is rather complex and can affect performance significantly if done improperly . It would be best to implement a query action which transfers essential data to your external database in such a scenario.

Regards
Axel