[Building Sakai] Stats for File Storage

[Sam Ottenhoff]

Here is the basic idea tested on MySQL (not Oracle):

    SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(cr.IN_COLLECTION,
\"private/meleteDocs\", \"group\"), \"/\", 3), \"/\", -1) AS site_id,
SUM(FILE_SIZE) as aggregate_size
    FROM CONTENT_RESOURCE
    GROUP BY site_id
    ORDER BY aggregate_size DESC


On Mon, Jan 27, 2014 at 9:23 AM, May, Megan Marie <mmmay at iu.edu> wrote:

>  Has anyone ever run a report to get the file storage by site or by
> user?
>
>
>
> Wondering if anyone has something we can reuse.
>
>
>
> Thanks,
>
> Megan
>
>
>
>
>
> Megan May
>
> Manager, Learning Management Systems / Kuali Student Development
>
> UITS Enterprise Student Systems
>
> Enterprise Software Division
>
> Indiana University
>
> Office:  317-274-4528
>
>
>
> _______________________________________________
> 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 HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140128/4776bab8/attachment.html