Help desk teams often find that the OneDrive storage quota page in the Microsoft 365 admin center does not list all users who should have a OneDrive site. This makes it impossible to check storage usage or adjust quotas for those missing accounts. The root cause is typically a licensing or provisioning delay that prevents a user’s OneDrive from being created. This article explains why users go missing from the storage quota report and provides a step-by-step checklist to identify, provision, and manage quotas for every user.
Key Takeaways: OneDrive Storage Quota – Missing Users Checklist
- Microsoft 365 admin center > Users > Active users: Verify each user has an assigned SharePoint Online license before checking OneDrive provisioning status.
- SharePoint admin center > Sites > Active sites: Filter by template USER to see all OneDrive sites that currently exist in the tenant.
- Set-SPOSite -Identity -StorageQuota: PowerShell command to set storage quota for a OneDrive site that already exists but does not appear in the admin center quota list.
Why Users Are Missing from the OneDrive Storage Quota Report
The OneDrive storage quota section in the Microsoft 365 admin center (under Reports > Usage > OneDrive or SharePoint admin center > Storage) only displays users who have an active OneDrive site provisioned. A user’s OneDrive is not created automatically when a license is assigned. The site is created only when the user signs in to OneDrive for the first time or when an admin triggers provisioning via PowerShell. Until that happens, the user does not appear in any storage quota report.
Licensing and Provisioning Dependencies
A user must have a SharePoint Online license (included in most Microsoft 365 business and enterprise plans) before OneDrive can be provisioned. Even with a license, the OneDrive site is not created until the user explicitly accesses OneDrive or the admin runs the Request-SPOPersonalSite cmdlet. Users who have never signed in to OneDrive will always be missing from the storage quota list.
Deleted or Orphaned Users
If a user was deleted from Active Directory or Microsoft 365, their OneDrive site enters a retention period. During this time, the site may still consume storage but will not appear in the standard quota report for active users. Help desk teams must check the SharePoint admin center’s Deleted sites section to find these orphaned sites.
Checklist: Find and Provision Missing OneDrive Users
Use the following steps to identify every user who should have a OneDrive and ensure their site is provisioned and visible in the storage quota report.
- Export the licensed user list
Go to Microsoft 365 admin center > Users > Active users. Click Export users to download a CSV file. Open the CSV and filter the Licenses column for rows that include SharePoint Online (Plan 1) or SharePoint Online (Plan 2). Save this filtered list as your master user roster. - Export existing OneDrive sites from SharePoint admin center
Open SharePoint admin center > Sites > Active sites. Click Export to download a CSV of all sites. In the CSV, filter the Template column for USER. This shows all OneDrive sites that are already provisioned. Compare this list to your master user roster from step 1. Any user on the master list but not in the USER template list is missing a OneDrive site. - Provision missing OneDrive sites with PowerShell
Install the SharePoint Online Management Shell and connect to your tenant withConnect-SPOService -Url https://yourtenant-admin.sharepoint.com. For each missing user, run:Request-SPOPersonalSite -UserMailBoxes user@domain.com
This cmdlet queues the OneDrive site creation. The site may take up to 24 hours to appear, but most are ready within 15 minutes. - Verify provisioning and check storage quota
After provisioning, return to SharePoint admin center > Sites > Active sites. Filter by template USER and locate the new site. Click the site name, then select Settings. Under Storage limit, you will see the current quota. The user now appears in the storage quota report under Reports > Usage > OneDrive. - Set storage quota for existing sites that do not appear in the report
If a OneDrive site exists (confirmed in step 2) but does not appear in the admin center’s storage quota report, run the following PowerShell command to ensure the quota is set explicitly:Set-SPOSite -Identity https://yourtenant-my.sharepoint.com/personal/user_domain_com -StorageQuota 104857600
Replace the URL with the exact OneDrive site URL and the quota value in bytes (for example, 104857600 equals 100 GB). After running this command, refresh the storage quota report in the admin center.
If Users Are Still Missing After Provisioning
OneDrive site exists but user shows zero storage
When a user has never uploaded files, the storage quota report may show 0 GB used. This is normal. The user is not missing; they simply have no data. To confirm the site is active, use SharePoint admin center > Sites > Active sites and filter by the user’s email domain.
Deleted user’s OneDrive still consumes storage
Go to SharePoint admin center > Sites > Deleted sites. Look for sites with template USER. These sites consume storage but do not appear in the active user quota report. You can either restore the user to reclaim the storage or permanently delete the site from the deleted sites list. To delete, select the site and click Delete. This frees the storage quota immediately.
License assigned but OneDrive creation fails silently
If Request-SPOPersonalSite returns no error but the site never appears, check the Microsoft 365 service health dashboard for SharePoint Online provisioning delays. In rare cases, the user’s UPN contains special characters (like an underscore) that block site creation. Rename the user’s UPN in Microsoft 365 admin center > Users > Active users > select user > Manage username to remove special characters, then run the provisioning cmdlet again.
OneDrive Storage Quota Management Methods
| Item | Admin Center GUI | PowerShell |
|---|---|---|
| View all OneDrive sites | SharePoint admin center > Sites > Active sites > Filter by template USER | Get-SPOSite -Template USER -IncludePersonalSite $true |
| Set storage quota for a single site | Site settings > Storage limit > Enter value in GB | Set-SPOSite -Identity URL -StorageQuota bytes |
| Provision a new OneDrive site | Not available in GUI | Request-SPOPersonalSite -UserMailBoxes email |
| See storage used per user | Reports > Usage > OneDrive > View details | Get-SPOSite -Template USER | Select Title, StorageUsageCurrent |
| Recover deleted OneDrive site | SharePoint admin center > Sites > Deleted sites > Restore | Restore-SPODeletedSite -Identity URL |
Help desk teams can now identify every user who should have a OneDrive site, provision missing sites using PowerShell, and adjust storage quotas through the admin center or cmdlets. As a next step, run the Get-SPOSite -Template USER | Export-CSV command weekly to automate the comparison with your licensed user list. For tenants with more than 500 users, consider using the Microsoft 365 Admin Center > Reports > Usage scheduled export feature to receive a daily CSV of OneDrive storage data.