[Deploying Sakai] Sakai usage statistics built from database
Yzelle, Sonette
SYzelle at unisa.ac.za
Tue May 4 03:39:05 PDT 2010
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"
More information about the production
mailing list