[Deploying Sakai] Sakai usage statistics built from database
jean-francois.leveque at upmc.fr
Mon May 3 05:20:08 PDT 2010
Thanks for the reminder, Steve.
Do the Server-wide Reports need new tables or do they get their results
from existing tables?
Steve Swinsburg a écrit :
> 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
> <mailto: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
More information about the production