When you check OneDrive for Business storage quotas in the Microsoft 365 admin center, some users who should appear in the quota report are missing. This usually happens because the user is not assigned a OneDrive license, the user never signed in to OneDrive, or the device management policy hides the user from the report. This article explains why users disappear from the storage quota view and provides step-by-step fixes to show missing users on managed devices.
Key Takeaways: Restore Missing Users in OneDrive Storage Quota Reports
- Microsoft 365 admin center > Billing > Licenses: Verify each missing user has an active OneDrive for Business (Plan 1 or Plan 2) license assigned.
- OneDrive admin center > Sync > Device management: Ensure device-level policies do not restrict visibility of managed devices in the quota report.
- PowerShell cmdlet Get-SPOSite -IncludePersonalSite $true: Use SharePoint Online Management Shell to list all OneDrive sites and confirm user provisioning status.
Why Users Are Missing from the OneDrive Storage Quota Report
The OneDrive storage quota report in the Microsoft 365 admin center shows a list of users who have an active OneDrive site. A user can be missing for three technical reasons.
First, the user must have a OneDrive for Business license assigned. Without a license, the system does not provision a OneDrive site, so the user never appears in the quota report. Second, the user must have signed in to OneDrive at least once. The first sign-in triggers site creation. If the user never signs in, no site exists and the user is absent from the report. Third, on managed devices, group policies or mobile device management settings can hide users from the quota view. For example, a policy that restricts OneDrive to specific device platforms may exclude users who only access OneDrive from unapproved devices.
Additionally, the OneDrive storage quota report only displays users who are assigned to the tenant and have a OneDrive site. Deleted users, users without a license, and users who never signed in are not listed. Understanding these conditions helps you identify why a specific user is missing.
Steps to Show Missing Users in the OneDrive Storage Quota Report
Follow these steps in order. Each step addresses one of the root causes described above.
- Verify the user has a OneDrive for Business license
Sign in to the Microsoft 365 admin center at admin.microsoft.com. Go to Billing > Licenses. Select the OneDrive for Business license product. Check the list of assigned users. If the missing user is not listed, assign the license. Select the user, then select Assign license. Choose OneDrive for Business Plan 1 or Plan 2 and select Save. Wait 15 minutes for the license to propagate. - Confirm the user has signed in to OneDrive
Ask the user to sign in to OneDrive at onedrive.com or through the OneDrive sync app on a managed device. The first sign-in automatically creates the user’s OneDrive site. After sign-in, wait up to 24 hours for the site to appear in the quota report. You can also force site creation using PowerShell. Open SharePoint Online Management Shell. RunRequest-SPOPersonalSite -UserMailAddresses "user@domain.com". Then runGet-SPOSite -IncludePersonalSite $true | Where-Object {$_.Owner -eq "user@domain.com"}to confirm the site exists. - Check device management policies that hide users
Go to the OneDrive admin center at admin.onedrive.com. Select Sync > Device management. Review the Device management policy settings. If the policy restricts OneDrive to specific device platforms or requires device compliance, users accessing OneDrive from noncompliant devices may not appear in the quota report. To show all users, set the policy to Allow access from any device or ensure the missing user’s device meets the compliance requirements. Save the policy and wait 30 minutes for changes to apply. - Use PowerShell to list all OneDrive sites
Open SharePoint Online Management Shell. Connect to your tenant:Connect-SPOService -Url https://domain-admin.sharepoint.com. Run:Get-SPOSite -IncludePersonalSite $true -Limit All | Select-Object Url, Owner, StorageQuota, StorageUsageCurrent. This command shows every OneDrive site, including those not visible in the admin center. If the user’s site appears here but not in the quota report, the issue is with the admin center filter or device policy. If the site does not appear, the user needs a license or first sign-in. - Refresh the storage quota report
In the Microsoft 365 admin center, go to Reports > Usage > OneDrive for Business. Select Storage. Click Refresh at the top of the report. If the user still does not appear, clear your browser cache or open an InPrivate/Incognito window. Sign in again and check the report.
If Users Are Still Missing After the Main Fixes
The user shows in PowerShell but not in the admin center
This indicates the OneDrive site exists but the admin center filter excludes it. Go to the OneDrive admin center and select User. Ensure the Show users with no activity filter is enabled. Also check the Device platform filter. If it is set to a specific platform like Windows, users on macOS or mobile devices will be hidden. Change the filter to All platforms and save.
The user was recently assigned a license but still missing
License assignment can take up to 24 hours to fully provision a OneDrive site. If the user has signed in and 24 hours have passed, run the PowerShell command from step 4 to check if the site exists. If the site exists, the report refresh may be delayed. Wait another 24 hours. If the site still does not appear, contact Microsoft Support with the user’s UPN and the output of the PowerShell site listing.
The user is a guest or external user
Guest users with a OneDrive for Business license can have a OneDrive site. However, the storage quota report in the admin center may not display guest users by default. To see guest users, go to the OneDrive admin center, select User, and change the user type filter to All users. Guest users will now appear in the report. Note that guest OneDrive sites are subject to the same storage quota as internal users.
| Item | Admin Center Quota Report | PowerShell Get-SPOSite |
|---|---|---|
| Data source | Microsoft 365 usage reports | SharePoint Online site collection |
| Includes licensed users who never signed in | No | No |
| Includes unlicensed users | No | No |
| Honors device management filters | Yes | No |
| Shows guest users by default | No | Yes |
| Refresh interval | Up to 24 hours | Real-time |
The storage quota report in the admin center is designed for quick consumption but has limitations with device policies and guest users. PowerShell gives you a complete, unfiltered list of all OneDrive sites. Use PowerShell when the admin center does not show a user you know exists.
Now you can identify and fix the root cause of missing users in the OneDrive storage quota report. Start by checking the user’s license assignment and first sign-in status. If the user still does not appear, review device management policies and use PowerShell to confirm the site exists. For a permanent view of all users, run the PowerShell site listing weekly and export the results to a CSV file for auditing.