how to do statistics

[tfaudot]

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 is there an method that is triggered each time a page change occurs which I could override?

thanks!

[samuel_penn]

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.

[tfaudot]

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?

[tfaudot]

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

[sumitweirminera]

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]

[sumitweirminera]

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