Use PowerShell to get the available tenant storage use and quota in SharePoint Online


  • When I user Powershell (get-SPOTenant) to get the storagequota and the StorageQuotaAllocated values, then these values do not mach the values as shown in the SharePoint Admin Center.

    Values shown with PowerShell:

    Values shown in the SharePoint Admin Center (Site Collections):

    The Storage settings are set to automatic:

    Is there a way to get the values as shown in the SharePoint Admin Center by PowerShell? Our idea is to schedule the script and get notified when we are reaching the tenant storage quota.

    Monday, April 3, 2017 6:10 PM

All replies


    Hi ReinoutD,

    For this issue, I suggest you creating a new thread in SharePoint online forum:

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thanks for your understanding.

    Best Regards, 

    Lisa Chen 

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Monday, April 24, 2017 10:17 AM
  • But... this is Microsoft Online Services  >  Microsoft Online: SharePoint Online isn't it?



    Monday, April 24, 2017 10:29 AM
  • The forums for O365 and SharePoint online are a bit of a mess.

    The short version: Don't trust the numbers in PowerShell, the UI is correct.

    It use to be that SharePoint only allowed you to give out as much storage as you owned. ie if you had 2TB of storage you could have 2 sites with 1TB each, and no more. Then they allowed you to over-provision, where you could tell 20 sites that they can use up to 1TB (knowing that none of them are likely to go over 100GB) and you'd be fine as long as they stay under the numbers.

    When MS made this change they did not at the time re-build all the PowerShell commandlets to update the behaviour to acknowledge the change in rules and assumptions. I haven't checked to see if any/all of these have been fixed later but the UI is the definitive number without question.

    Wednesday, April 26, 2017 9:51 AM
  • So, what powershell command will get you what is shown in the UI?!?

    Thursday, December 6, 2018 10:59 AM