cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Folder disk space usage report

Highlighted
Newbie

Folder disk space usage report

How can I produce an Intralink 3.x report that shows how much total disk space is used by all the files (all versions)in a particular folder?I will soon be replicating a set of folders to a new remote facility.Before I do so, I need to have an idea of how much disk space will be required.In a WorkSpace, I can add "File Size" to the table display, but this is not an option in CommonSpace.I don't see anything in the client or DSMU that addresses my need.Gerry Champoux Williams International
Lead Engineer 2280 E. West Maple Road
Information Technology Walled Lake, MI 48390
' (248) 960-2816
7 (248) 960-2607
* <u>-</u>
þ <u>www.williams-int.com</u>

1 REPLY 1

RE: Folder disk space usage report - answer

Thanks to all that replied.Several people had an SQL script that did exactly what i wanted.Here is the first one I used:set timing on
set head on
set linesize 130
set pagesize 1000column "Folder Path" format a75
column "Number of Objects" format 999,999,999
column "Folder Size in Bytes" format 999,999,999,999SPOOL folder-size.txtSELECT
fol.FOLPATH "Folder Path",
count(pif.PIVID) "Number of Objects",
sum(f.FSIZE) "Folder Size in Bytes"
FROM
PDM.PDM_FOLDER fol,
PDM.PDM_PRODUCTITEM pi,
PDM.PDM_BRANCH br,
PDM.PDM_PRODUCTITEMVERSION piv,
PDM.PDM_PRODUCTITEMVERFILE pif,
PDM.PDM_FILE f
WHERE
fol.FOLID = pi.FOLID
AND pi.PIID = br.PIID
AND br.BRID = piv.BRID
AND pif.PIVID = piv.PIVID
AND f.FID = pif.FID
AND fol.FOLPATH like 'Root Folder/KWC/YAR/SUPPLIERS/BEHR%'
GROUP BY fol.FOLPATH
;SPOOL off