OneDrive Admin Checklist: storage quotas show missing users for Microsoft 365 admins

As a Microsoft 365 admin, you might open the OneDrive admin center to check storage quotas and find that some users are missing from the list. This happens because the storage quota report only shows users who have ever signed into OneDrive or who have a license that includes SharePoint Online. If a user has never accessed OneDrive, their account does not appear in the quota view. This article explains why users go missing from the storage quota list and provides a step-by-step checklist to identify, verify, and resolve missing user data.

The root cause is that OneDrive storage quotas are tied to the user’s personal site in SharePoint Online. A personal site is provisioned only when the user signs in to OneDrive or when an admin triggers site creation via PowerShell. Users who have not performed either action will not have a personal site, so they will not appear in the storage quota report. Additionally, users without an appropriate license or with a blocked sign-in status are excluded from the report entirely.

This article covers the exact steps to audit your tenant for missing users, create personal sites for them, and verify that storage quotas apply correctly. You will also learn how to generate a complete user list using Microsoft 365 admin center reports and PowerShell. By following this checklist, you can ensure that every licensed user is accounted for in your storage quota management.

Why Users Are Missing from the OneDrive Storage Quota Report

The OneDrive storage quota report in the Microsoft 365 admin center lists users who have a personal site provisioned in SharePoint Online. A personal site is created automatically the first time a user signs in to OneDrive or when an admin explicitly provisions it using PowerShell. Users who have never signed in to OneDrive and whose site has not been pre-provisioned will not appear in the report.

The report also filters out users who do not have a valid SharePoint Online license. For example, a user with Exchange Online only or an unlicensed user will not show up. Additionally, users whose accounts are blocked from sign-in or who have been deleted from Azure Active Directory are excluded. Understanding these filters is the first step to identifying missing users.

Personal Site Provisioning Prerequisites

A personal site requires the following conditions to be met:

• The user must have a SharePoint Online license assigned (part of Microsoft 365 E3, E5, Business Standard, or equivalent).
• The user must have signed in to OneDrive at least once, or an admin must have run the Request-SPOPersonalSite cmdlet for that user.
• The user must not be blocked from sign-in in the Microsoft 365 admin center.
• The user must have a valid email address and user principal name.

If any of these conditions are not met, the user will not have a personal site and will not appear in the storage quota report.

Checklist to Find and Fix Missing Users in Storage Quotas

Follow these steps in order to audit your tenant for missing users and ensure every licensed user has a personal site with the correct storage quota.

1. Export the full list of licensed users from the admin center
   Go to the Microsoft 365 admin center at admin.microsoft.com. Select Users > Active users. Click Export users to download a CSV file containing all active users. Open the CSV in Excel and filter the Licenses column to show only users with a SharePoint Online license. This is your master list of users who should have a OneDrive personal site.
2. Compare against the OneDrive storage quota report
   In the OneDrive admin center at admin.onedrive.com, go to Storage. The quota report lists all users with an existing personal site. Export this report using the Export button at the top of the page. Compare the two lists side by side. Any user in the licensed user CSV but not in the OneDrive quota report is a missing user.
3. Identify users who have never signed in to OneDrive
   In the Microsoft 365 admin center, go to Reports > Usage > OneDrive usage. This report shows active users per day. For a comprehensive view, use the Audit log in the Microsoft 365 Defender portal. Search for File accessed activities under OneDrive. Users with zero activity have never signed in.
4. Pre-provision personal sites for missing users using PowerShell
   Install the SharePoint Online Management Shell if you have not already. Connect to SharePoint Online using Connect-SPOService -Url https://yourtenant-admin.sharepoint.com. Run the following command to pre-provision personal sites for all missing users: Request-SPOPersonalSite -UserEmails "user1@domain.com","user2@domain.com". You can pass an array of email addresses from your missing user list. This cmdlet creates a personal site for each user without requiring them to sign in.
5. Verify the storage quota report after provisioning
   Wait up to 24 hours for the personal sites to fully provision. Return to the OneDrive admin center and refresh the storage quota report. The previously missing users should now appear. Check that their allocated storage quota matches your tenant default or any custom quota you have set.
6. Set or update storage quotas for new users
   If you need to apply a custom storage quota to the newly provisioned users, use the Set-SPOSite cmdlet. For example: Set-SPOSite -Identity https://yourtenant-my.sharepoint.com/personal/user1_domain_com -StorageQuota 10485760 sets a 10 GB quota. Run this for each user or script it against your list.

If Users Still Do Not Appear After Provisioning

Some users may remain missing even after you pre-provision their personal sites. The following issues are the most common causes and their fixes.

User has no SharePoint Online license assigned

A user must have a license that includes SharePoint Online. Check the user’s license assignment in the Microsoft 365 admin center under Users > Active users > select user > Licenses and apps. If SharePoint Online is not toggled on, enable it. The personal site will be created the next time the user signs in to OneDrive, or you can run Request-SPOPersonalSite again after the license change takes effect.

User is blocked from sign-in

If a user’s sign-in status is blocked in the Microsoft 365 admin center, their personal site cannot be provisioned. Go to Users > Active users > select user and check the Sign-in status under the Account tab. If blocked, unblock the user. After unblocking, run Request-SPOPersonalSite again.

User has been deleted from Azure Active Directory

Deleted users are permanently removed from the storage quota report. If you need to restore a deleted user, go to the Microsoft 365 admin center and select Users > Deleted users. Find the user and click Restore. Restored users will reappear in the quota report after their personal site is re-provisioned. If the site was already deleted, you must run Request-SPOPersonalSite again.

User’s personal site was deleted manually

An admin may have deleted a user’s OneDrive site from the SharePoint admin center. To recover it, go to the SharePoint admin center at admin.sharepoint.com, select Sites > Deleted sites, find the user’s personal site URL, and click Restore. After restoration, the user will appear in the storage quota report again.

OneDrive Admin Center vs PowerShell: Comparison for Storage Quota Management

Item	OneDrive Admin Center	SharePoint Online PowerShell
User visibility	Only users with existing personal sites	All users with a SharePoint Online license
Provisioning capability	Cannot create personal sites	Can pre-provision sites with Request-SPOPersonalSite
Bulk operations	Limited to exporting the report	Supports scripting for hundreds of users
Storage quota changes	Per-user quota in Storage settings	Set-SPOSite -StorageQuota for bulk updates
Audit log access	Basic usage reports only	Search-UnifiedAuditLog for detailed activity

The OneDrive admin center is best for a quick visual check of current storage usage. PowerShell is required for provisioning missing users and for bulk quota changes. Use both tools together to maintain an accurate storage quota inventory across your tenant.

You can now audit your tenant for missing users in the OneDrive storage quota report using the exported licensed user list and PowerShell provisioning. Start by comparing the admin center report with your licensed user CSV, then run Request-SPOPersonalSite for any user that is missing. After provisioning, verify that the quota report updates within 24 hours. For ongoing management, schedule a monthly PowerShell script to check for new licensed users without a personal site and pre-provision them automatically. This prevents missing user gaps before they affect your storage reporting.