List of subfolders level1 and folder size

Hi,

anyone having livereport to display list of subfolders level 1 and their sizes?

I have report separately to count the size of a folder and list of subfolders but having difficulty to merge them both in one report.

regards,

Baber.

Find more posts tagged with

Comments

Abdul Khan

I have one report to fetch all the immediate subfolders and the item count of these subfolder. I have modified it to fetch the size of all the documents inside those subfolder. Following is the sql:

select d.dataid as 'Nick Name',
d.name as 'Folder Name',
( select sum(dv.datasize)
   from dtreeancestors da, dtree dt, dversdata dv
   where dt.dataid=da.dataid and dt.subtype=144 and dt.dataid=dv.docid
   and da.ancestorid=d.dataid) as 'Folder Size'
from dtree d
where d.subtype=0 and d.parentid=<dataid of folder>

This works on SQL Server and requires DtreeAncestors table atble table. Give a try and let see if it works for you.