[Deploying Sakai] Sakai usage statistics built from database

Steve Swinsburg steve.swinsburg at gmail.com
Mon May 3 03:46:23 PDT 2010

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:

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.


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 

More information about the production mailing list