SharePoint Online Automation - Checking Site Quota For SharePoint Online Tenant

Today, I am writing about SharePoint Online Automation script for checking the Site Quota. SharePoint Online or Office 365 Automation provides powerful proficiencies to automate the tasks with SharePoint online so as to reduce human efforts and errors as well.

In this post, I will cover a scenario where you connect to SharePoint Online using SharePoint Online PowerShell Management and display the list of all provisioned site collection URLs and Site Quota for an Office 365 tenant. This post is mainly geared towards getting you started with SharePoint Online or Office 365 Automation. Once prepared with this knowledge, you can repeat the tasks easily and hassle-free.


First, we need to have an Office 365 subscription and SharePoint Online Management installed on your local system. If you don't already have them, you may want to register for the free trial version of Office 365. I also recommend reading the below articles before you start with this demonstration.


 Given below is the step by step solution with screenshots.

Open SharePoint ISE with Admin account and enter the following script.

  1. Import - Module Microsoft.Online.SharePoint.Powershell  
  2. $UserName = "Global account"  
  3. $Password = Your Password '  
  4. $UsagePercentagelimit = "1"  
  5. #Hash Table to hold results  
  6. $groups = @ {}  
  7. #Setup Credentials to connect  
  8. $Credentials = New - Object System.Management.Automation.PSCredential($UserName, (ConvertTo - SecureString $Password - AsPlainText - Force))  
  9. # Connect - MsolService - Credential $Credentials  
  10. Connect - SPOService - Url "" - Credential $Credentials  
  11. foreach($spoSite in (Get - SPOSite - Limit all - IncludePersonalSite: $false)) {  
  12.     $groups.Add($spoSite.Url, @ {})  
  13.     $StorageGB = [System.Math]::Round(($spoSite.StorageUsageCurrent / 1024), 2)  
  14.     $QuotaGB = ($spoSite.StorageQuota / 1024)  
  15.     $groups[$spoSite.Url].Add("QuotaGB", $QuotaGB)  
  16.     $groups[$spoSite.Url].Add("StorageGB", $StorageGB)  
  17.     if ($QuotaGB - eq 0) {  
  18.         $UsagePercentage = [math]::Round($StorageGB, 2) * 100  
  19.     } else {  
  20.         $UsagePercentage = [System.Math]::Round(($spoSite.StorageUsageCurrent / $spoSite.StorageQuota) * 100, 2)  
  21.     }  
  22.     $groups[$spoSite.Url].Add("Size", $spoSite.StorageUsageCurrent)  
  23.     $groups[$spoSite.Url].Add("UsagePercentage", $UsagePercentage)  
  24. }  
  25. $exp = @("Url,Storage USed,Storage Limit,Percentage Used %,")  
  26. Foreach($g in $groups.keys) {  
  27.     if ($($groups[$g]["UsagePercentage"]) - ge $UsagePercentagelimit) {  
  28.         $exp += ("$($g)""$($groups[$g]["  
  29.             StorageGB "])""$($groups[$g]["  
  30.             QuotaGB "])""$($groups[$g]["  
  31.             UsagePercentage "])" - join ",")  
  32.     }  
  33. }  
  34. $exp | Out - File "C:\testing\Quota.csv" - Encoding ascii - Force  
In the above script, you need to modify the below part.

  • $UserName="Global account" Enter your Global Admin Account email address
  • $Password =Your Password' Enter Your Account Password, make sure you are keeping this password in the single quote or else it will throw an error.
  • $UsagePercentagelimit ="1” Enter the result you want to get Maximum % site usages Result.
  • Connect-SPOService -Url "" -Credential $Credentials Enter Your tenant id here to connect with SPO service.

    $exp | Out-File "C:\testing\Quota.csv" -Encoding ascii -Force Enter out file path with Force command so it will overwrite existing same named file
Once you are done with the above modification, press f5 and wait for some time to get the result in the given file location.

You may see some warning message that you can ignore.

NoteMake sure you have entered correct username and password in order to proceed with the above PowerShell script.
Once the script is completed, navigate to the output file and you can see that the result has been written.

Open the CSV file and see the result format as excepted.

The above result will bring the result of storage used by Site collection only.

Up Next
    Ebook Download
    View all
    View all