Get file size of all files under specific folder

Mathias_Dresske

I want to see the accumulated size of all documents under a specific node.

 

I get count using following SQL.

[Show the amount of documents under 817979 and subnodes which have been created this year]

SELECT
    count(d.dataid)
FROM
    dtree d,
    dtree p
WHERE
    d.parentid = p.dataid
AND d.dataid IN
    (
        SELECT
            dataid
        FROM
            dtree START WITH dataid = 817979 CONNECT BY prior dataid = ABS(parentid))
AND d.subtype IN (144)
AND d.CREATEDATE > TO_DATE('2014-01-01','yyyy-mm-dd');

 

How must that be modified to get the total size?

Colin_Schmidt

You'd have to include the DVERSDATA table.  If you only care about the most current Version, you can match dtree.versionnum to dversdata.version, otherwise if you want all possible bytes, you'd skip version compare.  sum(dv.datasize).

Colin J. 

On Thu, Dec 11, 2014 at 5:32 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Get file size of all files under specific folder

Posted bymathias.dresske@tui-infotec.com (Dresske, Mathias)On 12/11/2014 05:28 AM

I want to see the accumulated size of all documents under a specific node. I get count using following SQL.[Show the amount of documents under 817979 and subnodes which have been created this year]SELECT     count(d.dataid) FROM     dtree d,     dtree p WHERE     d.parentid = p.dataid AND d.dataid IN     (         SELECT             dataid         FROM             dtree START WITH dataid = 817979 CONNECT BY prior dataid = ABS(parentid)) AND d.subtype IN (144) AND d.CREATEDATE > TO_DATE('2014-01-01','yyyy-mm-dd'); How must that be modified to get the total size?

---

[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 (mwv.com) 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.