I got a warning email from Microsoft stating that my organization is out of SharePoint Online storage. I was surprised at first, and even thought it was spam. But turns out, that running out of space on SharePoint Online is a thing.
To view the total and available free storage space currently for your organization, go to Active sites in the SharePoint admin center, and check the numbers at the top right corner of the page.
So how is the total number calculated in the first place?
According to SharePoint Limits, if you are a small business, you probably get 1 TB plus 10 GB per license purchased. But the math doesn’t really add up here. I don’t actually have 170 licensed users in this tenant. So it still seems to be a mystery to me.
Now that I am almost out of the space. I have two choices, either pay an additional monthly fee to get more space or delete some old sites to free up more space.
If you choose to go with the latter, you will need a detailed usage report to see where to begin the process.
In Admin Dashboard, go to Reports > Usage, and click View More under SharePoint activity.
Switch to Site Usage, and you will see the detailed usage of each site listed a little bit down the page.
However, for privacy concerns, both Site URL and Site owner columns are concealed. The report actually is useless with all concealed numbers and letters. To avoid that, you will need to go to Settings > Org settings, click on Reports, and uncheck the option “Display concealed user, group, and site names in all reports”.
Once done, refresh the Site Usage page and click on the Export button to download the usage list.