Friday, April 17, 2015

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 the 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 command line and run: 
Stsadm -o EnumSites -url http://Sharepoint-web-app-URL 

This command line retrieves all details as listed above in XML format. Lets export that XML to a file and get it in Excel for better analysis. Run:
Stsadm -o EnumSites -url http://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

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...