topic Re: how to do statistics in Alfresco Archive

how to do statistics

tfaudot — Thu, 31 Jul 2008 08:27:35 GMT

Hello,I'm trying to collect some statistics about the usage of alfresco in my company.I would like to get into my database a "top 10" pages which are the most visited.How should I proceed to collect such an information?Should I include in every page a small script that logs the access in the DB? Or

Re: how to do statistics

samuel_penn — Thu, 31 Jul 2008 10:56:09 GMT

Have you looked at the audit options?

http://wiki.alfresco.com/wiki/Audit_Configuration

I've only just started looking at this myself (as in, this morning), so not sure if it can be configured to track page views (it doesn't seem to using the default configuration, but does track document creation etc), but it may do what you want. Audit information is written into the alf_audit_fact database table.

Sam.

Re: how to do statistics

tfaudot — Thu, 31 Jul 2008 12:42:35 GMT

Thanks a lot, after reading the wiki about auditing that should do the trick 🙂

but unfortunately I didn't succeed in enabling the auditing as described in the wiki…

I created the custom-audit-services-context.xml and auditConfig.xml files, I putted them in WEB-INF\classes\alfresco\extension

I enabled the auditing by changing "false" into "true" in the auditConfig.xml

but when I launch alfresco and play around a bit all my audit tables in my database aren't populated…
What have I done wrong?

Re: how to do statistics

tfaudot — Thu, 31 Jul 2008 12:46:59 GMT

My fault… those files need to be copied under the "shared" directory… now it's working 🙂

Re: how to do statistics

sumitweirminera — Fri, 01 Aug 2008 12:28:16 GMT

Hi,

I followed the steps indicated in the post and after logging in to alfresco. This is the screen I get to see. Please advice.

[img]C:/audit.bmp[/img]

Re: how to do statistics

sumitweirminera — Fri, 01 Aug 2008 12:32:50 GMT

Hi,

I followed the steps indicated in the post and after logging in to alfresco. This is the following informtion I get to see in Tabular format, Since I cannot paste tabular format, I have converted to .csv format. First line is the table header and rest are information. Please advice.

User Name,Application,Service,Method,Timestamp,Failed,Message,Arg 1,Arg 2,Arg 3,Arg 4,Arg 5,Return,Thowable,TX
demo2,SystemMethodInterceptor,TemplateService,buildDefaultModel,8/1/2008 16:45,OK,,workspace://SpacesStore/fd3c1cbd-5f8f-11dd-8302-9d3069cbca1a,workspace://SpacesStore/ebe76cfc-5f8e-11dd-8302-9d3069cbca1a,workspace://SpacesStore/fd32a6da-5f8f-11dd-8302-9d3069cbca1a,workspace://SpacesStore/f2f77096-5f8e-11dd-8302-9d3069cbca1a,org.alfresco.web.ui.repo.component.template.DefaultModelHelper$1@c653f,"{template=workspace://SpacesStore/f2f77096-5f8e-11dd-8302-9d3069cbca1a, userhome=workspace://SpacesStore/fd32a6da-5f8f-11dd-8302-9d3069cbca1a, person=workspace://SpacesStore/fd3c1cbd-5f8f-11dd-8302-9d3069cbca1a, companyhome=workspace://SpacesStore/ebe76cfc-5f8e-11dd-8302-9d3069cbca1a, imageresolver=org.alfresco.web.ui.repo.component.template.DefaultModelHelper$1@c653f, date=Fri Aug 01 16:45:11 IST 2008}",,1ba38fd7-5fbb-11dd-af17-a509047098bb