LiveReport that shows data size for each Folder/Category in Content Server 10.0

Michael_Hernandez

Hello,

Does anyone have an example of a LiveReport that will tell me the total size  in GB for each top level folder in Content Server 10.0?

Thanks,

Michael

Nizar Ghazal

Quoted Michael Hernandez on 01/18/2018 04:54 PM:

Hello,

Does anyone have an example of a LiveReport that will tell me the total size  in GB for each top level folder in Content Server 10.0?

Thanks,

Michael

You could use something like what was posted in: https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=71539647&objAction=viewincontainer&ShowReplyEntry=71536506#forum_topic_71536506

 

Or here: https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=60924728&objAction=viewincontainer&ShowReplyEntry=60917488#forum_topic_60917488

 

SELECT COUNT(DBrowseAncestors.DataID) AS "Count", SUM(DVersData.DataSize)/1024 AS "FileSize IN KB"
FROM DBrowseAncestors 
JOIN DVersData ON DBrowseAncestors.DataID = DVersData.DocID WHERE DBrowseAncestors.AncestorID = %1

 

This provides the total amount of files and their size in KB, for a specific folder. You could repurpose it, to get multiple folders, but that seems very heavy-handed. I'd suggest just querying 1 root-level folder at a time.