Report showing capacity usage by group

Emanuele_Riccardo

Hi,

I was wondering if it is possible to create a live report that returns a list of all the groups and how much disk space they are using?  i.e. HR - 2gb, Planning - 10gb.

I've been searching through the forum but I have been unable to find such a report or see if it's possible.

Many thanks for any assistance

Angus Gillies

Access

Lori_Himsl

Try this (Oracle DB – not sure for SQL Server): select sum(datasize)/(1024*1024) "Size (Meg)", count(*) "Number of doc versions", sum(datasize)/(count(*)*1024) "Avg Size (K)", b.name from dtree, dversdata, kuaf a, kuaf b where (a.id=dtree.userid) and (dversdata.docid=dtree.dataid) and (b.id = a.groupid) group by b.name order by 1 desc

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, September 12, 2011 9:45 AM
To: eLink Recipient
Subject: Report showing capacity usage by group

 

Report showing capacity usage by group

Posted by basistechnical@glasgow.gov.uk (Riccardo, Emanuele) On 2011/09/12 09:43

 

Hi, I was wondering if it is possible to create a live report that returns a list of all the groups and how much disk space they are using?  i.e. HR - 2gb, Planning - 10gb. I've been searching through the forum but I have been unable to find such a report or see if it's possible. Many thanks for any assistance Angus Gillies Access

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Livelink Server:	knowledge-wlweb01