Report on SharePoint Quota settings across all Site Collections

Alexis Daniel

April 03, 2013

All Post

SharePoint Quota settings across all Site Collections

It is useful to see what the storage maximums are on each site collection. There are two key values. One is the level above which a warning will be issued weekly. The other is the absolute maximum a site collection can reach before it is turned read-only. Here’s a script that will dump the values in a CSV format easily structured for a presentable report:

$webapp = Get-SPwebapplication "http ://SharePoint"
$Sep=","
Write-Host "Site, Maximum in MB, Warning in MB"
 
 
$webapp | get-spsite -Limit ALL | ForEach-Object {
$i++;
$JPsite = $_;
write-host "$($JPSite.url)$($sep)$($JPsite.Quota.StorageMaximumLevel  / 1MB )MB$($sep)$($JPsite.Quota.StorageWarningLevel / 1MB )MB"
}
$JPsite.dispose()
$webapp.dispose