LiveReport_folder size and path

Ken_West

Hello,

I am looking for a LiveReport that will display the following:

Data Size (Folder size in MB), File Count, Folder ID, Folder Name and Folder Path. We are using SQL. Has anyone created such a report?

 

Narasimha_Rao

Hi,

Try this below query.

Inputs:

Type: Container   Prompt: Folder

Param %1: User Input 1

WITH n(ownerid,parentid, dataid, subtype, name, docname,Datasize,docid, pathstr) 

AS (SELECT d.ownerid,d.parentid, d.dataid, d.subtype, name, name,dv.Datasize,dv.docid, 

CAST ('' as VARCHAR(MAX)) 

FROM dtree d, dversdata dv 

WHERE parentid =%1 and d.DataID = dv.versionid 

UNION ALL 

SELECT nplus1.ownerid,nplus1.parentid, nplus1.dataid, nplus1.subtype,nplus1.name, n.docname, n.Datasize,n.docid, case when pathstr ='' then (cast(nplus1.Name AS varchar(max))) else (cast(nplus1.Name AS varchar(max)) + ':' + pathstr) END

FROM dtree as nplus1, n 

WHERE n.parentid = nplus1.dataid ) 

SELECT sum(n.datasize)/1023.9/1023.9  'Data Size (MB)', Count(n.name)as 'File Count',%1 'Folder ID',(SELECT Name FROM DTree WHERE (DataID = %1)) 'Folder Name',n.pathstr 'Folder Path' from n where n.parentid = -1 GROUP BY n.dataid,n.pathstr

Thanks and Regards,
Narsi
Supai Systems,
Bangalore, India.
e-mail  : narsi@supaisystems.com
website: www.supaisystems.com

On Thu, Feb 2, 2012 at 7:01 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

LiveReport_folder size and path

Posted byken.west@seattlechildrens.org (West, Ken)On 02-01-2012 20:25

Hello, I am looking for a LiveReport that will display the following: Data Size (Folder size in MB), File Count, Folder ID, Folder Name and Folder Path. We are using SQL. Has anyone created such a report?

---

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