Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM

Do you know the STSADM command-line tool can do this, still in SharePoint 2013? Yes! It can get you a quick peek view of all site collections in the given web application. It gets you details such as:

  • Storage space allocated – Storage used, warning and maximum levels
  • Site collection GUIDs
  • Site collection database names
  • Primary and Secondary Owners

Simply trigger the command line and run: 

Stsadm -o EnumSites -url https://Sharepoint-web-app-URL 
Get Site Collection Inventory with STSADM

This command-line retrieves all details as listed above in XML format. Let’s export that XML to a file and get it in Excel for better analysis. Run:

Stsadm -o EnumSites -url https://Sharepoint-web-app-URL > SitesInfo.xml 

Once completed, Open the XML file in Microsoft Excel, choose “As an XML table.”

and you should get the table as below:

PowerShell script to get site collection size: How to check site collection size in SharePoint 2013 with PowerShell?

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM

  • What is the location of this xml which gets generated upon using STSADM command

    Reply

Leave a Reply