Using Pivot Table to List all Site Collections Sizes within a SharePoint 2010 Farm

Video length: 2:44

Video description: This video walks through generating a Pivot table in Excel that exposes a list of all Site Collections along with their size from the WSS_Logging Database of a SharePoint 2010 Farm.

Documented video steps below:

To Create Reports from the Logging Database:

  • Launch Microsoft Excel
  • Switch to the Data tab
  • Under Get Exernal Data, select From Other Sources and select from SQL Server
  • Next to Server name type the host name of your SQL Server instance that houses your WSS_Logging Database
  • On the next screen, choose WSS_Logging under the Select the database that contains the data you want option
  • From the grid that appears below with a list of all the tables, scroll a bit and select the SiteInventory table
  • Finish the wizard
  • On the Import Data popup screen, choose PivotTable Report and click OK
  • From the PivotTable Field list select the checkboxes next to “MachineName” then “ServerUrl” then “SiteUrl” and then “SiteSize”
  • Review your results

Leave a Comment