Looking for SQL Statement to Obtain Total Workspace Size (Folder, Subfolders, Documents)

Chad Latka

.Looking for SQL Statement to obtain the Total Workspace Size of  (Folder -- Subfolders -- Documents)  in Megabytes (MBs) and or Gigabytes (GBs)

We are using SQL so Connect By Prior does not work to traverse hierchies.

What we have is similar to the DTreeAncestors table  --  we have a SSIS package that runs a stored procedure daily that build a table of ParentIDs.

Not sure how to construct the SQL query to get the DataSize of Folder with Subfolders and Documents.

Example of tblParentIDs

ParentID FolderID Source
2480        2480  Root Folder Name
2480        2480  Root Folder Name Abbrev.
2480        72758  Root Folder Name Abbrev.
2480        2324  Root Folder Name Abbrev.
2480        24953  Root Folder Name Abbrev.
2480       483941  Root Folder Name Abbrev.
2480       36660  Root Folder Name Abbrev.
2480        2325  Root Folder Name Abbrev.
2480       2482  Root Folder Name Abbrev.
2480       4586427  Root Folder Name Abbrev.

Colin_Schmidt

Search this area and you'll find either an exact same Report or one similar in either code or as a LR attached.

Is this for Oracle or MS/SQL?

Colin J. 

On Mon, Oct 6, 2014 at 1:38 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

[Attachments exceeded pre-set size limits. Use the links provided to access]

LiveReport for Datasize of Documents in a Parent Folder and Sub Folders

Posted bychad.latka@hii-ingalls.com (Latka, Chad)On 10/06/2014 01:32 PM

Looking for a SQL LiveReport that would display the total datasize sum in MBs(megabytes) and GBs(gigabytes) of documents for a Parent folder and any Sub folders for Livelink 9.7.1 We have a stored procedure that runs daily that builds a list of  (ParentIDs,  FolderIDs,  Source) for specific containers  -- ParentID based on principle of the DTreeAncestors table.  However we are not using Recommender so this table is obsolete in our environment. Please see attached.

Attachment Links:

Current Report Details.txt(2 KB)

---

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

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.