In this article, I would like to share the steps to get a site collection details in the farm. This solution can be applied for SharePoint 2010, 2013 and SharePoint 2016.

If we are going to Google it, we will see many results which will giveus exact details in one script. In case we have the multi-farm or single SharePoint server farm, and the requirement is to get site collection details with the below information, we need to collect the web application's and site collection's details from the farm, like Web Application name, URL, Site collection Name, URL, Content DB, Size of Content DB, Created Date, Site owner and others in CSV format.

Below is the script which will perform this activity for us:

  1. If ((Get-PSSnapin | where {$_.Name -match "SharePoint.PowerShell"}) -eq $null)
  2. {
  3. Add-PSSnapin Microsoft.SharePoint.PowerShell
  4. }
  5. Clear-Host
  8. $ServerName = HostName #Bring your Server Name
  9. $webapps = Get-SPWebApplication
  10. $Output = "C:\$ServerName.csv" #Output file
  13. $SiteDataCollection = @() # Array to store data
  14. foreach ($webapp in $webapps){
  16. $webappurl = $webapp.URL;
  17. $webappname=$webapp.DisplayName
  18. $sites=get-spsite -limit all -WebApplication $webapp.URL
  20. foreach ($site in $sites)
  21. {
  22. $ContentDB = Get-SPContentDatabase -site $site.url
  24. $SiteData = New-Object PSObject
  25. $SiteData | Add-Member -type NoteProperty -name "Web Application URL" -value $webappurl
  26. $SiteData | Add-Member -type NoteProperty -name "Web Application Name" -value $webappname
  27. $SiteData | Add-Member -type NoteProperty -name "Site URL" -value $site.url
  28. $SiteData | Add-Member -type NoteProperty -name "Database Name" -value $ContentDB.Name
  29. $SiteData | Add-Member -type NoteProperty -name "Database Size" -value $($ContentDB.DiskSizeRequired /1024/1024)
  30. $SiteData | Add-Member -type NoteProperty -name "Date Created" -value $site.RootWeb.Created
  31. $SiteData | Add-Member -type NoteProperty -name "OWner" -value $site.Owner
  33. $SiteDataCollection += $SiteData
  35. }
  37. }
  39. $SiteDataCollection | Export-Csv -Path $Output -Force
  41. Write-Host "Successfully Completed" -ForegroundColor DarkRed

Copy the above script in PowerShell ISE of any SharePoint Server in the farm and click on Start.

You will be getting the result on the defined path with the server name.