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

Tags:

Your name:
Title:
Comment:
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.