SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anyone know of a tool that lists all site collections and subsites together with quote size/usage?

share|improve this question
up vote 5 down vote accepted

I've used a free tool from CodePlex for this, and its worked out really well:

You'll have to run it a separate time for each site collection you want to get numbers for, but the only really problem I had with it. I like the way it outputs the results to a comma-separated value (CSV) file for you, makes it alot easier to get that data into a readable, manageable, and reportable format.

If you need sizing for each site collection, try STSADM's EnumSites operation, I believe it displays the storage used by each site collection, and you can easily pipe its output to a text file as well.


share|improve this answer
Thanks John. Very useful and did the trick. I found I had to rename the CSV files to .txt in order to get Excel 2007 to format it properly but otherwise a great little tool. – j.strugnell Nov 25 '09 at 14:25

I'm sure there are some third party tools out there that you can pay for that does this. At work we wrote our own tool that dumps all of the site information into a db where we can quickly look up that info using sql statements or if we needed to expose it elsewhere, we could build an app around it. The code is not that difficult to get the information you want.

share|improve this answer

SharePoint Manager 2007 off of will do most of this but it is a lazy-load tool in that you have to click on the specifics to obtain the data and doesn't export easily.

You could use also use Powershell to wrap around stsadm.exe that John mentioned above to enumerate your Site Collections, then for each one of those enumsites to gather all their information (you will need a bit of XPath getting the information formatted), and then easily export the data to .csv's or insert into a database. If interested in some of the scripts, just let me know.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.