aug.
17
Written by:
MOLEHAND
2011. 08. 17. 2:43
Az alábbi SQL script megmutatja melyik mappa mekkora méretű az adott SharePoint adatbázisban:
SELECT v.[Id], d.DirName
,count(v.[Version]) MaxNumberOfVersions
,sum(v.[Size]) TotalDocLibSize,max(v.[Size]) LargestDocSize
FROM [dbo].[AllDocVersions] v join [dbo].AllDocs d
on v.id=d.id
group by v.id , d.DirName order by 4 desc
Tags: