AnsweredAssumed Answered

Project folder size

Question asked by Jonathan Poole on Dec 29, 2018
Latest reply on Jan 2, 2019 by Francisco Guzman

I'd like to calculate the total disk space used by all file versions in all project folders. Here is the T-SQL query that I have so far:

 

select p.Path as Project

     , count(r.RevNr) as FileCount

     ,sum(r.FileSize) /1048576 as TotalMB

from documents d

     join DocumentsInProjects dip on dip.DocumentID = d.DocumentID

     join projects p on p.ProjectID = dip.ProjectID

     join revisions r on r.DocumentID=d.DocumentID

group by p.path

order by TotalMB desc

 

I'm thinking that this is not exactly correct since some file versions in the database to not have actual physical files in the archive folder structure.

Outcomes