OneDrive Admin Checklist: storage quotas show missing users for offboarding workflows

When you run the OneDrive storage quota report in the Microsoft 365 admin center, you may notice that some users who should appear are missing from the list. This typically happens because the storage quota report only shows users who have already synced files to OneDrive at least once. For offboarding workflows, missing users can delay data retention and transfer processes. This article explains why users are missing from the storage quota report and provides a step-by-step checklist to locate and manage those users during offboarding.

Why Users Are Missing from the OneDrive Storage Quota Report

The OneDrive storage quota report in the Microsoft 365 admin center pulls data from the OneDrive sync service. It only includes users who have a OneDrive site provisioned and have uploaded or synced at least one file. Users who have never opened OneDrive or who have not synced any files will not appear in this report. This is by design: the report is meant to show actual storage consumption, not potential capacity.

For offboarding workflows, the missing users are often newly created accounts, users who have not yet launched OneDrive, or users whose OneDrive site was deleted as part of a previous offboarding. The admin center storage quota report cannot distinguish between these cases. As a result, you may incorrectly assume that no data exists for those users and skip essential steps like transferring files to a manager or retaining data for compliance.

Additionally, the storage quota report does not show users who have a OneDrive license assigned but have not yet provisioned a OneDrive site. Provisioning occurs the first time the user signs into OneDrive or when an admin runs the Set-SPOSite cmdlet. Until then, the user has no storage to report.

Checklist: Locate and Manage Missing Users During Offboarding

Use the following checklist to find users missing from the storage quota report and ensure your offboarding workflow covers all accounts. Perform these steps in the order listed.

1. Verify the user exists in Active Users
   Go to the Microsoft 365 admin center at admin.microsoft.com. Navigate to Users > Active users. Search for the missing user by name or email. If the user is not listed, the account may have been deleted or never created. Check the Deleted users page or create the account if needed. If the user is listed but has no OneDrive activity, proceed to step 2.
2. Check OneDrive usage report for the specific user
   In the admin center, go to Reports > Usage > OneDrive. Click View more under the OneDrive files chart. Use the date range filter to cover the user’s employment period. If the user appears here, note the Storage Used (MB) value. A value of 0 means the user has a OneDrive site but no files. A missing entry means no site exists.
3. Run the SharePoint Online Management Shell
   Open Windows PowerShell as an administrator. Run Connect-SPOService -Url https://-admin.sharepoint.com and enter your admin credentials. Then run:
   Get-SPOSite -IncludePersonalSite $true -Limit All | Where-Object {$_.Url -like "-my.sharepoint.com/personal/"} | Select-Object Url, StorageUsageCurrent
   This lists all OneDrive sites in the tenant with their current storage usage. Find the user’s URL (format: https://-my.sharepoint.com/personal/__com). If the user’s URL is missing, the OneDrive site has not been provisioned.
4. Provision the OneDrive site for a missing user
   If the user’s OneDrive site does not exist and the user still needs offboarding, provision the site using PowerShell:
   Request-SPOPersonalSite -UserMailAddresses "user@domain.com"
   Wait up to 15 minutes for the site to create. Then run the Get-SPOSite command from step 3 again to confirm the site exists. The storage usage will show 0 MB until the user uploads files.
5. Transfer files from the missing user’s OneDrive
   If the user has a OneDrive site with files, use the Microsoft 365 admin center to transfer ownership. Go to Users > Active users, select the user, then click OneDrive > Transfer files. Enter the email of the manager or another user who will receive the files. Click Transfer. This moves all files to the target user’s OneDrive root folder. The original user’s OneDrive is then set to read-only for 30 days before deletion.
6. Retain the OneDrive site for compliance
   If the organization requires data retention, place a hold on the OneDrive site instead of deleting it. In the SharePoint admin center, go to Active sites, find the user’s OneDrive site, and select it. Click Policies > Add policy > Preservation hold library. Configure the hold duration. This prevents automatic deletion even after the user’s license is removed.
7. Remove the user’s OneDrive license
   After transferring files or applying a hold, remove the OneDrive license from the user. In the admin center, go to Users > Active users, select the user, click Licenses and apps, uncheck OneDrive for Business, and save changes. The OneDrive site remains accessible per the retention policy.

If the Storage Quota Report Still Shows Incomplete Data

The storage quota report shows zero users when I expect many

This occurs when the report is filtered by a date range or group that excludes most users. In the admin center, go to Reports > Usage > OneDrive and clear any group filters. Set the date range to cover the last 90 days or longer. If the report still shows zero users, verify that OneDrive usage reporting is enabled. Go to Settings > Org settings > Reports and ensure Show OneDrive usage data is turned on.

I cannot find a user who definitely had files last week

The user’s OneDrive site may have been deleted by an automated offboarding script or by a previous admin action. Check the SharePoint admin center Deleted sites list. If the site is there, select it and click Restore. The site and its files are available within 93 days of deletion. After that, the data cannot be recovered without a backup.

PowerShell returns no results for Get-SPOSite with personal site filter

This usually means the SharePoint Online Management Shell is not connected to the correct tenant or the user does not have a OneDrive license. Verify the connection URL matches your tenant. Then check the user’s license assignment in the admin center. If the license is present but the site still does not appear, run Request-SPOPersonalSite as described in step 4 above.

Methods to Find Missing Users: Admin Center vs PowerShell

Item	Microsoft 365 Admin Center	SharePoint Online Management Shell
User discovery	Shows only users with synced files	Shows all provisioned OneDrive sites
Provisioning control	Cannot provision a missing site	Can provision a site with Request-SPOPersonalSite
Storage usage data	Shows MB used for active users	Shows StorageUsageCurrent in bytes
Offboarding actions	Transfer files and remove license	Set site to read-only or delete via Remove-SPOSite
Retention hold	Available via SharePoint admin center	Available via Set-SPOSite -LockState

Use the admin center for quick checks on active users. Use PowerShell when you need a complete inventory of all OneDrive sites, including those with zero storage, or when you need to provision a site for a missing user.

The checklist in this article helps you find users missing from the OneDrive storage quota report by cross-referencing Active Users, the OneDrive usage report, and the SharePoint Online Management Shell. For each missing user, you can provision a OneDrive site, transfer files, apply a retention hold, or remove the license as needed. As an advanced tip, schedule a weekly PowerShell script that runs Get-SPOSite with a filter for OneDrive URLs and exports the results to a CSV file. This gives you a complete list of all OneDrive sites, including those with zero storage, so no user is overlooked during offboarding.