[Deploying Sakai] Sakai usage statistics built from database

[Jean-Francois Leveque]

Thanks for the reminder, Steve.

Do the Server-wide Reports need new tables or do they get their results 
from existing tables?

Cheers,
Jean-Francois

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:
> http://jira.sakaiproject.org/browse/STAT-61
> 
> 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.
> 
> 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