[Deploying Sakai] Sakai usage statistics built from database

[Yzelle, Sonette]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.

HI Jean-Francois,

I don't know if this will really help you because we read the statistics per event and for a specific date.
At Unisa we run a daily script to store our stats per site and event daily and monthly in a different table.
Weekly we move our sakai-event and sakai-session data to an archive database.

Selects that I use to read data from the archive database is (Oracle):

getEventStatsMonthly
        "SELECT COUNT(*) AS A
        FROM   SAKAI_EVENT
        WHERE  EVENT = 'event'
        AND    TO_CHAR(EVENT_DATE,'YY-MM') = '"+forDate+"'";


getEventStatsPerSite
        "SELECT REF,COUNT(*) AS A
        FROM   SAKAI_EVENT
        WHERE  EVENT = 'event'
        AND    TO_CHAR(EVENT_DATE,'YYYY-MM-DD') = '"+forDate+"'"
        GROUP BY REF";

getEventStatsPerSiteMonthly
        "SELECT REF,COUNT(*) AS A
      FROM   SAKAI_EVENT
      WHERE  EVENT = 'event'
        AND    TO_CHAR(EVENT_DATE,'YYY-MM') = '"+forDate+"' "+
        GROUP BY REF";

Regards
Sonette

Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za

-----Original Message-----
From: Arlow, Magdaleen
Sent: Monday, May 03, 2010 3:50 PM
To: Yzelle, Sonette
Subject: FW: [Deploying Sakai] Sakai usage statistics built from database

Hi Sonette

DO you want to answer him?

Thanks
Magdaleen

-----Original Message-----
From: production-bounces at collab.sakaiproject.org [mailto:production-bounces at collab.sakaiproject.org] On Behalf Of Jean-Francois Leveque
Sent: 03 May 2010 11:16 AM
To: production at collab.sakaiproject.org
Subject: [Deploying Sakai] Sakai usage statistics built from database

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"