Get-SPOSite storage usage: StorageUsageCurrent and StorageQuota for every site

To see how much storage each SharePoint site uses, connect with Connect-SPOService -Url https://contoso-admin.sharepoint.com and read StorageUsageCurrent and StorageQuota from Get-SPOSite. Both are in megabytes:

Get-SPOSite -Limit All |
  Sort-Object StorageUsageCurrent -Descending |
  Select-Object Url,
    @{n='UsedGB';  e={[math]::Round($_.StorageUsageCurrent / 1024, 2)}},
    @{n='QuotaGB'; e={[math]::Round($_.StorageQuota / 1024, 2)}} |
  Format-Table -AutoSize

-Limit All is needed: without it Get-SPOSite returns at most 200 sites. Run it as a SharePoint Administrator.

The properties

The site object returned by the module has these storage properties; their names and .NET types in version 16.0.27709.12000, read offline:

Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking
[Microsoft.Online.SharePoint.PowerShell.SPOSite].GetProperties() |
  Where-Object Name -in 'Url','StorageUsageCurrent','StorageQuota','StorageQuotaWarningLevel','StorageQuotaType' |
  Sort-Object Name | ForEach-Object { '{0,-25} {1}' -f $_.Name, $_.PropertyType.Name }
'Set-SPOSite -StorageQuota type: ' + (Get-Command Set-SPOSite).Parameters['StorageQuota'].ParameterType.Name

StorageQuota              Int64
StorageQuotaType          String
StorageQuotaWarningLevel  Int64
StorageUsageCurrent       Int64
Url                       String
Set-SPOSite -StorageQuota type: Int64

OneDrive accounts

OneDrive sites are personal sites and are left out by default. Include them with the filter parameter set:

Get-SPOSite -IncludePersonalSite $true -Limit All -Filter "Url -like '-my.sharepoint.com/personal/'" |
  Select-Object Owner,Url,StorageUsageCurrent,StorageQuota

Change a site quota

Manual quotas apply only when the tenant's site storage management is set to Manual in the SharePoint admin center (with automatic management, setting a quota returns a generic error). Values are in MB:

# 100 GB quota, warning at 90 GB
Set-SPOSite -Identity https://contoso.sharepoint.com/sites/finance -StorageQuota 102400 -StorageQuotaWarningLevel 92160

When to use it

Use this report when the tenant storage pool is filling up, before you set manual quotas, or when a site owner reports that uploads fail because the site is full. Sorting by StorageUsageCurrent shows the few sites that hold most of the data, and comparing it with StorageQuota shows which sites are close to their limit. The same command with -IncludePersonalSite $true covers OneDrive accounts, which often account for a large share of the total.

Requirements

Export the report

For a spreadsheet, export the same calculated columns to CSV instead of formatting them for the screen:

Get-SPOSite -Limit All |
  Select-Object Url, Template, StorageUsageCurrent, StorageQuota, StorageQuotaWarningLevel |
  Export-Csv spo-storage.csv -NoTypeInformation -Encoding UTF8

-NoTypeInformation keeps Windows PowerShell 5.1 from writing a #TYPE line at the top of the file; see Export-Csv -NoTypeInformation.

Errors you may see

Fixes: No connection available, Current site is not a tenant administration site, SpoSitePipeBind conversion.

FAQ