SharePoint admin: How do you find the site(s) that have had the greatest growth over the past week?

Question

We had just under 1 TB of storage available for SharePoint and within the past couple of days it has dwindled to almost nothing. How do I find out which site, or sites, have consumed that buffer we had?

Answer 1

Hi @Richard Gibbons ,

As a SharePoint admin, you can access the SharePoint site usage report to gain insights into site activity and storage consumption. Here’s how:

1. In the admin center, go to Reports > Usage.
2. From the dashboard homepage, under Reports, select SharePoint.
3. Review the site usage report to understand trends and per-site details for all sites.

You can also export the report data to an Excel .csv file for further analysis. Keep in mind that the report covers trends over the last 7, 30, 90, or 180 days, and selecting a specific day shows data up to 28 days from the current date. Investigate the report to identify which site(s) contributed to the storage consumption.

Reference:https://learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/sharepoint-site-usage-ww?view=o365-worldwide

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.