OneDrive for Business storage quotas show missing users for Microsoft 365 admins: Fix Guide

Microsoft 365 admins often find that the OneDrive for Business storage quota report in the admin center does not list all licensed users. Some accounts appear to be missing from the list, making it difficult to track storage usage and enforce policies. This issue typically occurs when users have never signed in to OneDrive or when their site has not been provisioned. This guide explains the root cause and provides step-by-step methods to locate and fix missing users in storage quota views.

Why OneDrive Storage Quotas Show Missing Users

The Microsoft 365 admin center displays OneDrive storage quota data only for users who have an active OneDrive site. A OneDrive site is created automatically the first time a user signs in to OneDrive or when an admin manually provisions it. Users who have never signed in to OneDrive do not have a site, so they do not appear in the storage quota list. This is by design, but it creates a visibility gap for admins who need to see all licensed users.

Another reason for missing users is that their OneDrive site has been deleted or is in a quarantined state. Deleted sites are retained in the recycle bin for a period, but they are not listed in the active users report. Similarly, sites that are blocked due to legal hold or policy violations may not show in the standard quota view. The admin center GUI only surfaces active, healthy sites.

Finally, licensing issues can cause missing users. If a user does not have a valid SharePoint Online or OneDrive license assigned, their site will not be provisioned. The admin center will not display these users in the storage quota report because there is no underlying site to report on. Understanding these three root causes — never signed in, deleted/quarantined site, or missing license — is the first step to resolving the issue.

Steps to Find and Fix Missing Users in OneDrive Storage Quotas

Follow these methods to locate missing users and apply storage quotas. Use Method 1 first for a quick check. Use Method 2 for a complete inventory of all OneDrive sites.

Method 1: Check the Microsoft 365 Admin Center Report

1. Open the OneDrive usage report
   Go to the Microsoft 365 admin center at admin.microsoft.com. Navigate to Reports > Usage > OneDrive. This report lists all users who have an active OneDrive site. If a user is missing here, they likely have not signed in.
2. Export the report to CSV
   Click the Export button at the top of the report. Download the CSV file. Open it in Excel and sort by the Last Activity Date column. Users with a blank date have never signed in. The report will not show them, but the CSV may include placeholders for users with zero activity.
3. Check license assignment
   Still in the admin center, go to Users > Active Users. Select a user who is missing from the OneDrive report. Click the Licenses and apps tab. Verify that SharePoint Online (Plan 2) or OneDrive for Business (Plan 2) is assigned. If not, assign the license and wait 24 hours for the site to provision.

Method 2: Use SharePoint Online Management Shell to List All Sites

1. Install and connect the SharePoint Online Management Shell
   Open Windows PowerShell as an administrator. Run Install-Module -Name Microsoft.Online.SharePoint.PowerShell if the module is not installed. Then run Connect-SPOService -Url https://yourtenant-admin.sharepoint.com. Replace yourtenant with your tenant name.
2. Get all OneDrive sites including personal sites
   Run the following command:
   Get-SPOSite -IncludePersonalSite $true -Limit All | Where-Object {$_.Template -eq "SPSPERS"}
   This returns every OneDrive site, including those not shown in the admin center. Note the Url and StorageQuota values.
3. Identify users without a site
   Run this command to get all licensed users from Azure AD:
   Get-MgUser -All -Filter "assignedLicenses/any()" | Select-Object UserPrincipalName
   Compare the list of user principal names with the URLs from the previous step. Users with a UPN but no matching site URL have never had their OneDrive provisioned.
4. Manually provision a missing user’s OneDrive
   To create a OneDrive site for a user who has never signed in, run:
   Request-SPOPersonalSite -UserEmails "user@domain.com"
   Wait a few minutes, then run Get-SPOSite -IncludePersonalSite $true again to confirm the site appears.
5. Set a storage quota on a missing site
   If a site exists but is not listed in the admin center, you can still update its quota. Run:
   Set-SPOSite -Identity https://yourtenant-my.sharepoint.com/personal/user_domain_com -StorageQuota 10485760
   The value is in megabytes. 10485760 MB equals 10 GB. Adjust as needed.

Method 3: Restore a Deleted OneDrive Site

1. Check the SharePoint admin center recycle bin
   Go to the SharePoint admin center at admin.microsoft.com > SharePoint. In the left navigation, select Recycle bin. Look for deleted OneDrive sites. The site URL typically starts with https://yourtenant-my.sharepoint.com/personal/.
2. Restore the site
   Select the deleted site and click Restore. The site will be reactivated and should appear in the storage quota report within 24 hours.
3. Use PowerShell to restore a site
   If the site is not in the recycle bin, run:
   Get-SPODeletedSite -IncludePersonalSite $true | Where-Object {$_.Url -like "user"}
   Then run Restore-SPODeletedSite -Identity https://yourtenant-my.sharepoint.com/personal/user_domain_com.

If OneDrive Storage Quotas Still Show Missing Users

Users with no OneDrive site at all

If a user has a valid license but no site even after running Request-SPOPersonalSite, check that the user has signed in to OneDrive at least once. The site will not provision until the first sign-in or an admin-initiated request. Ask the user to visit https://portal.office.com/onedrive and sign in. After that, the site will appear in the quota report within a few hours.

Quota changes not reflecting in the admin center

After updating a storage quota via PowerShell, the admin center may take up to 24 hours to refresh. If the change does not appear, clear your browser cache or use an InPrivate/Incognito window to view the report. For immediate verification, run Get-SPOSite -Identity | Select-Object StorageQuota in PowerShell.

Missing users due to tenant sync restrictions

Some admins configure group-based sync restrictions that prevent certain users from accessing OneDrive. Go to SharePoint admin center > Policies > Access control and check the Device access and Network location policies. If a user is blocked by policy, their site will not be created. Remove the restriction or add the user to an allowed group.

Admin Center vs PowerShell: Finding Missing Users

Item	Microsoft 365 Admin Center	SharePoint Online PowerShell
User visibility	Only active OneDrive sites shown	All sites including unprovisioned, deleted, and quarantined
Quota modification	Per-user quota via user properties	Bulk quota changes with Set-SPOSite
Site provisioning	Not possible from admin center GUI	Request-SPOPersonalSite cmdlet available
License check	Integrated in user list	Requires Get-MgUser from Microsoft Graph
Report freshness	Up to 24-hour delay	Real-time data from SharePoint Online

The admin center is suitable for a quick overview of active users. PowerShell provides the complete picture and allows you to act on sites that the GUI hides. For routine quota management, use PowerShell to ensure no user is missed.

You can now identify and resolve missing users in OneDrive storage quotas using both the admin center and PowerShell. Start by running the Get-SPOSite -IncludePersonalSite $true command to get a complete inventory. Then provision any missing sites with Request-SPOPersonalSite and set their quotas with Set-SPOSite -StorageQuota. For ongoing monitoring, create a scheduled PowerShell script that compares your licensed user list against existing OneDrive sites and alerts you to gaps.