MOLEHAND Solutions

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
group by , d.DirName order by 4 desc


Your name:
Security Code
Enter the code shown above in the box below
Add Comment    Cancel  


Discount offer

 I’ve already tried several providers. Currently all of our projects are placed at MOLEHAND, because they provide real services not only a piece of a computer. Any kind of new problem crops up, I can always count on a fast and expert reaction.