OneDrive report
Size per user, departed users, sharing
One row per OneDrive with its owner, size, files and last activity; the OneDrives of people who have left, with the date Microsoft will delete them and any secondary owner; and, if you ask, the links shared from each. Nothing is changed.
Reads only. Nothing in SharePoint is changed.
How it runs
- Sign in once. Reports › OneDrive report. Sign in as a SharePoint administrator: OneDrives are listed from the admin centre.
- Sharing, if you want it. Also list the links shared from each OneDrive. Slow: every OneDrive is scanned.
- 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?
- The SharePoint administrator role.
- On App authentication, a site you are not an admin of is opened by making you a site collection admin for the run and removing that again at the end (the site-admin rule). Cert authentication needs no grant.
What will it not do?
- The deletion date is the owner's deletion date plus the tenant's OneDrive retention setting. Microsoft counts from when the account was deleted, so a disabled but not deleted account has no date yet.
- On User authentication, account states and Microsoft's usage figures need Microsoft Graph and are left blank, and the report says so.
- 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.