[Building Sakai] Tool usage analysis

[Algaze, Louis Contractor, eDataTech]

All,

I've developed some SQL which can be run against the database (version
2.7.1) for various tool usage numbers and/or presence in a site.  They
have not been fully vetted but I'm willing to share and welcome feedback
(see attached .txt file).  The Files/Space utilized SQL takes the longest
amount of time while others are pretty fast.

I use these queries as part of a proof of concept BI project I'm
developing.  Having this data is good so if we are planning on replacing a
tool we know which sites are using that tool.

Louis

On 2/14/12 12:12 PM, "Martin B. Smith" <smithmb at ufl.edu> wrote:

>On 02/14/2012 02:36 PM, Joshua Swink wrote:
>> Hi list. Does anyone have some scripts or other ways of analyzing and
>> getting reports on tool usage in Sakai? I'd like to see how much our
>> users depend on the various tools for their courses.
>>
>> Josh
>
>I'd be interested in these scripts too. IIRC, Michigan had some scripts
>that analyzed load balancer log output; I'd love it if I could find some
>to run against Apache 'combined' format logs. I've been planning to
>write some myself, but haven't gotten to it yet.
>
>Cheers all,
>-- 
>Martin B. Smith
>smithmb at ufl.edu - (352) 273-1374
>CNS/Open Systems Group
>University of Florida
>
>_______________________________________________
>sakai-dev mailing list
>sakai-dev at collab.sakaiproject.org
>http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>TO UNSUBSCRIBE: send email to
>sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>"unsubscribe"

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Sakai Tool SQLs.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120221/8c9aae76/attachment.txt