[Deploying Sakai] Sakai usage statistics built from database

[Nuno Fernandes]

Hi all,

Sorry for jumping in late - I was out of office last week.

Yes, STAT-61 provides some global sakai stats but there are a few
inconvenients:

   - requires that SAKAI_EVENT and SAKAI_SESSION to be intact;
   - queries are directed to these tables so:
      - it's slow
      - it doesn't use any new tables

We don't use this at production. One alternative is to add "SiteStats Admin"
tool to Administration Workspace, create a private report and set "All
sites" on the sites to report. This allows to report on all sites with
SiteStats tool and can give you stats like "most used tool"...

For other yearly stats we usually query database directly...

Hope it helps,
Nuno


On Tue, May 4, 2010 at 11:39 AM, Yzelle, Sonette <SYzelle at unisa.ac.za>wrote:

> 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"
> _______________________________________________
> 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"
>



-- 
Nuno Fernandes  .  { Analyst/Programmer }

|| web  . { http://www.ufp.pt  |  http://tinyurl.com/nfgrilo  |  follow_me @
nfgrilo }
|| work . { Universidade Fernando Pessoa  |  Praça 9 de Abril, 349  |
 4249-004 Porto }
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100510/8c83e7e3/attachment.html