size of all Personal Workspaces in Livelink

Hi,

I have created a livereport (Oracle) to calculate size of all Personal Workspaces in Livelink and sharing here in case someone need it.

select sum(datasize/1024) "Size in Kb",sum(datasize/(1024*1024)) "Size in MB" from dversdata where docid in(Select dataid from dtree start with dataid in (select id from kuaf where type=0) connect by prior dataid = parentid)

regards,

Baber.

Find more posts tagged with

Comments

Lindsay_Davies

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Baber,

Using connect by prior is not necessary and on a large system could cause delays to other users when the report runs for a long time.

Items in a workspace / volume are identified by having the same OwnerID value.

So the following statement will be more efficient.

For other subscribers, it would also be database independent, working with Oracle and SQL server.

select sum(datasize/1024) "Size in Kb",sum(datasize/(1024*1024)) "Size in MB" from dversdata where docid in ( select dataid from dtree where ownerid in ( select id*-1 from kuaf where type=0 ) )

Regards

Lindsay

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 February 22, Wed 05:35
To: eLink Recipient
Subject: size of all Personal Workspaces in Livelink

size of all Personal Workspaces in Livelink

Posted by baber.amin@dolphinenergy.com (Amin, Baber) On 02-22-2012 00:30

Hi, I have created a livereport (Oracle) to calculate size of all Personal Workspaces in Livelink and sharing here in case someone need it. select sum(datasize/1024) "Size in Kb",sum(datasize/(1024*1024)) "Size in MB" from dversdata where docid in(Select dataid from dtree start with dataid in (select id from kuaf where type=0) connect by prior dataid = parentid) regards, Baber.

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Baber_Amin

Thanks for your recommendations.