Inactive sites, OneDrives and groups
Workspaces nobody has used for months
Finds SharePoint sites, OneDrives and Microsoft 365 groups with no activity for the number of days you pick, from Microsoft's own usage reports. Nothing is changed.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- One row per site, OneDrive and Microsoft 365 group: owner, last activity, days since, files and size.
- Which inactive groups are teams, each pointing at Inactive teams (Teams admin), which can archive them.
How it runs
- Sign in once. Reports › Inactive sites, OneDrives and groups. Sign in as yourself with a role that can read Microsoft 365 usage reports.
- Pick the threshold. 30, 90, 180 or 365 days; 180 is the default.
- Run report. The run screen lists each thing it reads as it goes: Microsoft's reports, the directory, and each site. Stop offers Finish, which reads nothing new and builds the report from what was read, or Stop now.
- Read the result. The Done screen gives the headline and anything that could not be read. The workbook goes into History; Save report keeps a copy where you choose. Its About sheet names every source and what came of it.
What do you need?
- Reports Reader, Global Reader or Global Administrator. The report makes no SharePoint call.
What will it not do?
- Microsoft's usage reports reach back 180 days. At 365 days, a workspace with no activity in those 180 days is shown as exactly that.
- If the tenant hides user, group and site names in usage reports, the report says so, shows how to turn that off, and flags nothing.
- A read that did not happen is shown as not read, never as an empty result: a site the report could not open keeps its row, with why, and nothing is concluded from it.