Site Quota comes in handy when you wish to enforce the size limits in your SharePoint site collections. It lets you set the storage limit values and warning limit values, for better farm management.

The below script will bring forth the site quota and other related information, such as maximum storage limit, maximum storage warning, etc. for the entire farm. The output will be in CSV format.
  1. if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
  2. {
  3. Add-PSSnapin "Microsoft.SharePoint.PowerShell"
  4. }
  6. $templates = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.quotatemplates
  7. $tFound = $false
  8. $templateName = "No template found"
  10. $results = @()
  12. $sites = Get-SPSite -Limit ALL
  13. try
  14. {
  15. foreach ($site in $sites)
  16. {
  17. foreach ($qt in $templates)
  18. {
  19. if ($qt.QuotaId -eq $site.Quota.QuotaID)
  20. {
  21. $templateName = $qt.Name;
  22. $tFound = $true
  23. }
  24. }
  25. if ($tFound -eq $false)
  26. {
  27. $templateName = “No Template Applied”
  28. }
  29. $tFound=$false;
  31. $RowDetails = @{
  32. "Site URL" = $site.Url
  33. "Storage Used" = $site.Usage.Storage/1MB
  34. "Storage Available Warning" = $site.Quota.StorageWarningLevel/1MB
  35. "Storage Available Maximum" = $site.Quota.StorageMaximumLevel/1MB
  36. "Sandboxed Resource Points Warning" = $site.Quota.UserCodeWarningLevel
  37. "Sandboxed Resource Points Maximum" = $site.Quota.UserCodeMaximumLevel
  38. "Quota Name" = $templateName
  39. }
  40. $results += New-Object PSObject -Property $RowDetails
  41. $site.Dispose()
  42. }
  43. }
  45. catch
  46. {
  47. $e = $_.Exception
  48. $line = $_.InvocationInfo.ScriptLineNumber
  49. $msg = $e.Message
  51. Write-Host -ForegroundColor Red "caught exception: $e at $line"
  52. Write-Host $msg
  53. write-host "Something went wrong"
  54. }
  56. $results | Export-csv -Path C:\SiteQuotaDetailedInfo.csv -NoTypeInformation
  57. Write-Host "-------------------- Completed! -----------------------------"

And, here is a screenshot of the exported data in CSV (of course, with a little bit of styling in Excel).