How To Create an Inventory Report of All SharePoint Sites

Here’s a simple PowerShell script to create an inventory report of all sites (technically called webs) in your SharePoint Environment.

Important Notes:

  • We recommend running this script off peak usage periods
  • Adjust the $OutputPath variable to match your environment
  • See SPWeb Properties for additional properties to include in the report


Add-PSSnapin "Microsoft.SharePoint.Powershell" -EA 0
#Modify Output Path
$OutputPath = "E:\SharePointLogs"
Start-SPAssignment -global;
Get-SPSite -Limit All

Get-SPWeb -Limit All

Select Url, Title, LastItemModifiedDate

Export-CSV -Path ($OutputPath + "\SiteInventory.csv")
Stop-SPAssignment -global;

PPM Works is a full service Microsoft Project and Portfolio Management consultancy, focused on Microsoft Project Server and Microsoft SharePoint platforms.  We believe in partnering with our clients to exceed expectations and build long lasting rewarding partnerships. We are continuously building a knowledge base of multiple tips, tricks and solutions to make your use of Microsoft Project Pro as quick and easy as possible. Contact us for more information.

Stay updated with the latest of Project Online/Server 2013 with us: Subscribe. Check our future events!

Subscribe to our webcast email list for updates on our upcoming webinars! 

Visit our FAQ Page for access to our tool box.