nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Live Report for Volume Size of Recycle Bin

Maria_Chrysafidi

Hello!We would like to create a Live Report for retrieving the total size of the Recycle Bin per month or per user group with the following columns:Total Document NumberTotal Byte SizeWhich tables should we use besides the gdcRecycleBin?Many thanks in advance,Maria

Find more posts tagged with

Comments

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Message from <Adarsh.Lobo@shell.com> via eLink

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

Maria,

I don't think querying gdcrecyclebin is a good option because it lists only the dataid's which have been deleted. i.e. If a folder is deleted it which list only the dataid of the folder and not the dataids of the objects inside this folder.

You can query dtree. First you will need to identify the dataid of the RB folder created for the Month. i.e. If you want to find the doc count for say Oct 2009. Then browse through front end, RecycleBin -> 2009 -> 10. Note down the dataid of this RB container for Oct 2009.

Now you can use the below queries for Oracle RDBMS:

To get the doc count:

---------------------------

select count(1)

from dtree

where subtype=144

start with dataid=<dataid of this RB container for Oct 2009>

connect by prior dataid=abs(parentid)

Query to find the Total Datasize including all versions.

---------------------------------------------------------------------

select sum(dv.datasize/1021/1024) "Datasize in MB"

from dversdata dv,

(select dataid from dtree start with dataid=<dataid of this RB container for Oct 2009> connect by prior dataid=abs(parentid)) a

where a.dataid=dv.docid

Its always better to have an index created for abs(parentid). Alternatively you can run these using TOAD

Thanks,

Adarsh

-----Original Message-----
From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, October 13, 2009 8:59 PM
To: eLink Recipient
Subject: Live Report for Volume Size of Recycle Bin

Live Report for Volume Size of Recycle Bin Posted by maria.chrysafidi@siemens.com (Chrysafidi, Maria) on 2009/10/13 11:25

Hello!

We would like to create a Live Report for retrieving the total size of the Recycle Bin per month or per user group with the following columns:
Total Document Number
Total Byte Size

Which tables should we use besides the gdcRecycleBin?

Many thanks in advance,
Maria

Thomas_Sell

Hi - anybody know the way to cut out the recycle bin from the -2000 volume?

The example LiveReports don't work since the RB folder doesn't exist in dtree. Or how to filter out RB items in a LiveReport query?

Thanks in advance,

Tom Sell

JT3

LasVegas, NV.

Lindsay_Davies

Tom,

The Recycle Bin is its own volume.

So it is different to the Enterprise volume.

If you did a report against the Enterprise workspace volume) it will not have anything of the Recycle Bin included.

The following statement will sum the size of all vesinos of all dtree objects in the RecycleBin workspace.

Select sum(datasize) from dversdata where docid in (select dataid from dtree where ownerid in (select ownerid from dtree where subtype=3030))

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 June 29, Fri 23:28
To: eLink Recipient
Subject: RE Live Report for Volume Size of Recycle Bin

RE Live Report for Volume Size of Recycle Bin

Posted bytom.sell@jt3.com (Sell, Thomas) On 06-28-2012 17:47

Hi - anybody know the way to cut out the recycle bin from the -2000 volume?

The example LiveReports don't work since the RB folder doesn't exist in dtree. Or how to filter out RB items in a LiveReport query?

Thanks in advance,

Tom Sell

JT3

LasVegas, NV.

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Walt_Ruppar

Is there a subtype list somewhere for the different volumes? I’d like to do reports on other volumes such as E-mail and Project.

Thanx!

~Walt

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, June 29, 2012 10:53 PM
To: eLink Recipient
Subject: RE RE Live Report for Volume Size of Recycle Bin

RE RE Live Report for Volume Size of Recycle Bin

Posted by ldavies@opentext.com (Davies, Lindsay) On 06-29-2012 19:45

Tom,

The Recycle Bin is its own volume.

So it is different to the Enterprise volume.

If you did a report against the Enterprise workspace volume) it will not have anything of the Recycle Bin included.

The following statement will sum the size of all vesinos of all dtree objects in the RecycleBin workspace.

Select sum(datasize) from dversdata where docid in (select dataid from dtree where ownerid in (select ownerid from dtree where subtype=3030))

Regards

Lindsay

RE Live Report for Volume Size of Recycle Bin

Posted by tom.sell@jt3.com (Sell, Thomas) On 06-28-2012 17:47

Hi - anybody know the way to cut out the recycle bin from the -2000 volume?

The example LiveReports don't work since the RB folder doesn't exist in dtree. Or how to filter out RB items in a LiveReport query?

Thanks in advance,

Tom Sell

JT3

LasVegas, NV.

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Bhupinder_Singh

Here’s a list I have (can’t say if it is comprehensive or not though):

137 Release Volume

141 Enterprise Volume

142 Personal Volume

143 Discussion Volume

148 System Object Volume

150 Livelink (Virtual Root Volume)

161 Workflow Volume

162 Workflows Edit Volume

201 Project Home Volume

203 Projects (Virtual Projects Volume)

209 Channel Volume

210 Task List Volume

211 Reports Volume

301 Personal Volume

- Bhupinder

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, January 18, 2013 4:07 PM
To: eLink Recipient
Subject: RE RE RE Live Report for Volume Size of Recycle Bin

RE RE RE Live Report for Volume Size of Recycle Bin

Posted bywalt.ruppar@chemtura.com (Ruppar, Walt) On 01-18-2013 16:06

Is there a subtype list somewhere for the different volumes? I’d like to do reports on other volumes such as E-mail and Project.

Thanx!

~Walt

RE RE Live Report for Volume Size of Recycle Bin

Posted by ldavies@opentext.com (Davies, Lindsay) On 06-29-2012 19:45

Tom,

The R ecycle Bin is its own volume.!

So it is different to the Enterprise volume.

If you did a report against the Enterprise workspace volume) it will not have anything of the Recycle Bin included.

The following statement will sum the size of all vesinos of all dtree objects in the RecycleBin workspace.

Select sum(datasize) from dversdata where docid in (select dataid from dtree where ownerid in (select ownerid from dtree where subtype=3030))

Regard! s

Lindsay

RE Live Report for Volume Size of Recycle Bin

Posted by tom.sell@jt3.com (Sell, Thomas) On 06-28-2012 17:47

Hi - anybody know the way to cut out the recycle bin from the -2000 volume?

The example LiveReports don't work since the RB folder doesn't exist in dtree. Or how to filter out RB items in a LiveReport query?

Thanks in advance,

Tom Sell

JT3

LasVegas, NV.

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Colin_Schmidt

Here’s a LR that counts all objects by Subtype….maybe a few missing.

Colin J. Schmidt

MSLive/Livelink Admin

Tulsa, OK 74172

Colin.Schmidt@williams.com

If you have received this message in error, please reply to advise the sender of the error and then immediately delete this message.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, January 18, 2013 3:07 PM
To: eLink Recipient
Subject: RE RE RE Live Report for Volume Size of Recycle Bin

RE RE RE Live Report for Volume Size of Recycle Bin

Posted by walt.ruppar@chemtura.com (Ruppar, Walt) On 01-18-2013 16:06

Is there a subtype list somewhere for the different volumes? I’d like to do reports on other volumes such as E-mail and Project.

Thanx!

~Walt

RE RE Live Report for Volume Size of Recycle Bin

Posted by ldavies@opentext.com (Davies, Lindsay) On 06-29-2012 19:45

Tom,

The R ecycle Bin is its own volume.!

So it is different to the Enterprise volume.

If you did a report against the Enterprise workspace volume) it will not have anything of the Recycle Bin included.

The following statement will sum the size of all vesinos of all dtree objects in the RecycleBin workspace.

Select sum(datasize) from dversdata where docid in (select dataid from dtree where ownerid in (select ownerid from dtree where subtype=3030))

Regard! s

Lindsay

RE Live Report for Volume Size of Recycle Bin

Posted by tom.sell@jt3.com (Sell, Thomas) On 06-28-2012 17:47

Hi - anybody know the way to cut out the recycle bin from the -2000 volume?

The example LiveReports don't work since the RB folder doesn't exist in dtree. Or how to filter out RB items in a LiveReport query?

Thanks in advance,

Tom Sell

JT3

LasVegas, NV.

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

SubtypeList.txt

Walt_Ruppar

Thanks for the info Bhupinder. I figured out the subtype to be 750 for email volumes

Walt_Ruppar

Thanks Colin. That's a handy report. I figured out the subtype to be 750 for email volumes

Colin_Schmidt

You can also download the Schema Companion and Reference Guide for LES 9.7.1. it has a number of useful tables. They are not complete because of all the varying Subtypes and Auditing capabilities brought on by one module or another. Sometimes, all you can do it gather this information through trial and error.

Colin J. Schmidt

MSLive/Livelink Admin

918-573-6164

Personal Cell: 918-904-9223

One Williams Center

Tulsa, OK 74172

Colin.Schmidt@williams.com

If you have received this message in error, please reply to advise the sender of the error and then immediately delete this message.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 22, 2013 2:36 PM
To: eLink Recipient
Subject: RE RE RE RE Live Report for Volume Size of Recycle Bin

RE RE RE RE Live Report for Volume Size of Recycle Bin

Posted by walt.ruppar@chemtura.com (Ruppar, Walt) On 01-22-2013 15:30

Thanks for the info Bhupinder. I figured out the subtype to be 750 for email volumes

[To post a comment, use the normal reply function]
Topic:	Live Report for Volume Size of Recycle Bin
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center