[Deploying Sakai] Sakai usage statistics built from database

[Steve Swinsburg]

Hi Jean Francois,

Have you considered the 'Server-wide Reports' capability of Site Stats? This provides quite good reporting across an entire installation, but you need to activate it:
http://jira.sakaiproject.org/browse/STAT-61

serverWideStatsEnabled at org.sakaiproject.sitestats.api.StatsManager=true

I've attached a screenshot.

What kinds of stats do you need? Joins on SAKAI_EVENT, SAKAI_SESSION and SAKAI_USER_ID_MAP give you pretty much everything you need.

cheers,
Steve




On 03/05/2010, at 7:16 PM, Jean-Francois Leveque wrote:

> Hi all,
> 
> I would like to know which historical statitics you use in your 
> reporting that can be extracted from the database.
> 
> Can you provide the SQL requests to get those?
> 
> I use MySQL but could convert Oracle requests.
> 
> Best Regards,
> 
> Jean-Francois Leveque
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100503/3e84fb53/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen shot 2010-05-03 at 8.45.36 PM.png
Type: image/png
Size: 130532 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20100503/3e84fb53/attachment-0001.png