Disk space utilized in each repository on monthly basis.

S.Thilahi

Hi

Any one suggest,

1.How to display the disk space utilized in each repository on monthly basis through DQL

2.DQL to display the number of unique users accessing the repository per month

thanks in advance.

 

ckickel

Regarding your first question, you might start with:

select datetostring("r_creation_date",'yyyy/mm'), sum(r_full_content_size)

from dm_document(all)

group by datetostring("r_creation_date",'yyyy/mm')

order by 1

To answer the second question, I'd first need to know if you're auditing user logon events.