Get the size of all site collections for a Web application

Guest post from Trevor Eddolls, CEO iTech-Ed Ltd (www.itech-ed.com), specialists for IT consultancy, analysis, technical education and training, web design, writing, and editing solutions. Read more from Trevor on his mainframe blog and follow him on Twitter.

This week, Darren Pritchard, our SharePoint guru, lays out clearly exactly what needs to be done in order to find out the size of all site collections for a Web application in SharePoint 2007.

The first step is to create a batch file containing:

SET STSADM="c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\STSADM.EXE"

%STSADM% -o enumsites -url <Your Site> SiteStats.txt

Pause

Pretty obviously, where it says <Your Site>, you need to change that to the name of the Web application that you need to produce the statistics for.

Next you need to copy the batch file to your Web front-end server and run it.

The output will be in a file called SiteStats.txt. Open the file and for each site collection you will see ‘StorageUsedMB=’ and a value. It’s the value that you’re interested in.

On a completely different topic: the next Virtual CICS user group meeting will be on 8 November. More details about how to register can be found on the user group website at fundi.com/virtualcics.