Report on SharePoint Quota settings across all Site Collections

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
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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