topic Re: Analysis : Sharing alfresco data with other applications in Alfresco Archive

Analysis : Sharing alfresco data with other applications

zomurn — Mon, 20 Apr 2009 15:30:49 GMT

Hi,I need to do some stats with alfresco : who, when and what need to be stored somewhere and then I should be able to request this information given a date range for example : "How much Mr stuff processed document during the month of march in year 2007".My VERY GLOBAL question are :1) How to store

Re: Analysis : Sharing alfresco data with other applications

zaizi — Mon, 20 Apr 2009 15:56:01 GMT

You need to turn on audit service and configure it so it tracks all the activities you require.

You can then write a custom view in your database to list the things you are interested in. Alternatively, you can use your BI tool to query the Alfresco audit data.

This can then be reported on.

See http://wiki.alfresco.com/wiki/Auditing_Design_and_Implementation for some sample queries. NB: These queries might not work out of the box depending on the version of Alfresco you are using. You might need to update. But they provide a start.

Re: Analysis : Sharing alfresco data with other applications

zomurn — Mon, 20 Apr 2009 16:32:08 GMT

Thanks you very much for this first answer .

I just have a quick look at your link. Well informative !
I just need to know how to create a view as you said (through independent SQL script…append it to alfresco database init scripts ? Simple "SQL" not portable query inside MY alfresco dao layer (which contains only lucene queries at the moment ? HQL portable query inside MY alfresco dao layer ?)
Is auditing service expecting to audit for custom metadata ?
Some calculation based on custom metadata should be stored in the database directly (not though alfresco).
There will be no HTML view displayed : the statistic will go inside database…the BI tool will do the synthesis of all the available information.

Thanks again and I'am going to hardly investigate how to do and starting from audit service.

Re: Analysis : Sharing alfresco data with other applications

zaizi — Tue, 21 Apr 2009 08:09:06 GMT

I just need to know how to create a view as you said (through independent SQL script…append it to alfresco database init scripts ? Simple "SQL" not portable query inside MY alfresco dao layer (which contains only lucene queries at the moment ? HQL portable query inside MY alfresco dao layer ?)

Keep it simple. Just use independent SQL script depending on which database you are using. Alternatively, you can just use your BI tool to copy the relevant audit tables across and build the view or custom tables in your reporting database.

Is auditing service expecting to audit for custom metadata ?

Yes it should.

Re: Analysis : Sharing alfresco data with other applications

zomurn — Tue, 02 Jun 2009 09:24:24 GMT

I saw in database that workspace spacestore noderef are hardcoded.
So, inside alfresco if a delete the node (a cm:folder for example) and recreate it, all the queries are false then ….
Queries can't be "dynamic" ?