Monday, 12 September 2011

Get the size of all site collections for a Web application

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: on Tuesday 13 September the Virtual CICS user group meets. Rocket Software’s Charles Jones will be discussing “CICS TS 4.2: Leveraging event processing and high-performance Java”. More details about how to register can be found on the user group Web site at fundi.com/virtualcics.

If you need anything written, contact Trevor Eddolls at iTech-Ed.
Telephone number and street address are shown here.