Query to list documents with sizes under a folder and subfolders

Hi,

It's for SQL Server. I was wondering if someone can give me a Query to list documents with sizes under a folder and subfolders.

Thanks.

Find more posts tagged with

Comments

Colin_Schmidt

Do you want all documents and their byte-size?

Select dt.parentid, dtp.name “Parent”, dt.dataid, dt.name “Document”, dv.datasize

From dtreeancestorid dtan

Join dtree dt on dtan.dataid = dt.dataid and dt.subtype = 144

Join dtree dtp on dt.parentid = dtp.dataid

Join dversdata dv on dt.dataid = dv.docid and dt.versionnum = dv.version

Where dtan.ancestorid = %1

Colin J

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Friday, July 13, 2018 4:16 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Query to list documents with sizes under a folder and subfolders

Query to list documents with sizes under a folder and subfolders

Posted bybaber.amin@hatch.com (Amin, Baber) On 07/13/2018 05:15 PM

Hi,

It's for SQL Server. I was wondering if someone can give me a Query to list documents with sizes under a folder and subfolders.

Thanks.

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

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.