Get-Set OneDrive Site Collection Storage Quota Size using PowerShell

Get OneDrive Site collection Storage Quota Information:
To get the storage quota data for a particular OneDrive site, use this PowerShell cmdlet in SharePoint Online Management Shell
Get-SPOSite -Identity ""
This gets you the currently allocated storage quota data for a single site collection.

Get Storage Quota Details of All OneDrive Site collections
Use this script in SharePoint Online Management Shell.

#Get Credentials to connect to the SharePoint Admin Center
$Cred = Get-Credential

#Connect to SharePoint Online Admin Center
Connect-SPOService -Url $AdminSiteURL –credential $Cred

#Get all Personal Site collections and export to a Text file
$OneDriveSites = Get-SPOSite -Template "SPSPERS" -Limit ALL -includepersonalsite $True

[email protected]() 
# Get storage quota of each site
Foreach($Site in $OneDriveSites)
    $Result += New-Object PSObject -property @{ 
    URL = $Site.URL
    Owner= $Site.Owner
    Size_inMB = $Site.StorageUsageCurrent
    StorageQuota_inGB = $Site.StorageQuota/1024

$Result | Format-Table

#Export the data to CSV
$Result | Export-Csv "C:\Temp\OneDrive.csv" -NoTypeInformation
This script produces nice CSV report in below format and gives how much storage a OneDrive sites are consuming.
OneDrive Storage report using powershell

How to Set Storage Quota for OneDrive Site Collection?
By default, OneDrive site collections in Office 365 comes with 1TB storage quota. In some situations, you may want to either increase or decrease the storage allocation. Say, you want to increase storage quota for a particular OneDrive site collection to 2TB:
Set-SPOSite -Identity "" -StorageQuota 2097152 
set onedrive storage quota using powershell

Similarly, User's OneDrive storage quota can be reset to the default OneDrive storage quota
Set-SPOSite -Identity "" -StorageQuotaReset
To set the default storage quota for OneDrive sites at Tenant level, use:
Set-SPOTenant -OneDriveStorageQuota 2097152, More info here: Set the default OneDrive for Business Storage Space


  1. Brilliant Job, Thanks so much – It worked!

  2. Excellent job. Great blog site. Well done!!! Thank you!

  3. Can you set a Storage Quota with an activeDirectories attribut ? (for exemple "Title" attribut)

    1. Well, its just a matter of framing OneDrive for Business site URL. It uses the below format:

      E.g. If your tenant's domain is:, and your user name is :Salaudeen, then OneDrive URL is framed as:

  4. works great. How would you reset on all users (from csv file) instead of one?

  5. Can we export Active Users data only?


Please Login and comment to get your questions answered!

Powered by Blogger.