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 - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the 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

Your email address will not be published. Required fields are marked *