OneDrive Admin Checklist: storage quotas show missing users for tenant migrations

When you migrate users to a new Microsoft 365 tenant, you may find that the OneDrive storage quotas report shows missing users. These users are licensed and active but do not appear in the storage quota list in the Microsoft 365 admin center. This problem occurs because the OneDrive for Business site for each user has not been provisioned yet. In a tenant-to-tenant migration, OneDrive sites are created only after a user signs in to OneDrive for the first time in the new tenant. This article explains why users are missing from the storage quotas report and provides a step-by-step checklist to provision OneDrive sites for all migrated users.

Why Users Are Missing from the OneDrive Storage Quotas Report

In a tenant migration, user accounts and licenses are transferred to the new tenant. However, OneDrive for Business sites are not automatically created during the migration. Each user’s OneDrive site is provisioned only when that user signs in to OneDrive for the first time in the new tenant. Until that sign-in event occurs, the user does not have a personal site collection. The storage quotas report in the OneDrive admin center lists only users who have a provisioned OneDrive site. Therefore, any user who has not yet signed in to OneDrive will be absent from the report.

The OneDrive site provisioning process depends on the user having a valid OneDrive license assigned. If the license is present but the site has not been created, the user will still be missing from the storage quotas view. This is not a licensing error. It is a deliberate behavior in Microsoft 365. The site collection is created on demand to reduce unnecessary storage allocation.

How OneDrive Site Provisioning Works

When a user with a OneDrive license navigates to onedrive.com or opens the OneDrive sync client, Microsoft 365 checks whether a personal site collection exists for that user. If no site exists, the system creates one automatically. This process is called auto-provisioning. The site is created in the tenant’s default SharePoint content database. After the site is created, the user appears in the storage quotas report and the admin can manage storage limits, sharing permissions, and data retention policies.

Checklist to Provision OneDrive Sites for All Migrated Users

Use this checklist to ensure every migrated user has a provisioned OneDrive site and appears in the storage quotas report. Perform these steps in the order listed.

1. Verify OneDrive licenses are assigned to all migrated users
   Open the Microsoft 365 admin center. Go to Users > Active users. Select a user and review the Licenses and apps tab. Confirm that the OneDrive for Business license is turned on. Repeat for each user. If a user lacks the license, assign it before proceeding.
2. Install the SharePoint Online Management Shell
   Open Windows PowerShell as an administrator. Run the command Install-Module -Name Microsoft.Online.SharePoint.PowerShell. If you already have the module installed, run Update-Module -Name Microsoft.Online.SharePoint.PowerShell to get the latest version.
3. Connect to SharePoint Online
   In PowerShell, run Connect-SPOService -Url https://[tenant]-admin.sharepoint.com. Replace [tenant] with your tenant name. Enter your global admin credentials when prompted.
4. Provision OneDrive sites for all migrated users
   Run the following command to create OneDrive sites for a list of users:
   Request-SPOPersonalSite -UserEmails "user1@domain.com","user2@domain.com","user3@domain.com"
   To provision sites for all users in a CSV file, use this script:
   $users = Import-Csv -Path "C:\Users\Admin\Desktop\migrated_users.csv" | Select-Object -ExpandProperty Email
Request-SPOPersonalSite -UserEmails $users
   The CSV file must contain a column named Email with one email address per row. The cmdlet returns a confirmation message for each user. It does not show progress. Wait 15 to 30 minutes for the provisioning to complete.
5. Verify that the OneDrive sites were created
   After waiting, run Get-SPOSite -IncludePersonalSite $true -Filter "Url -like '-my.sharepoint.com/personal/'" | Select-Object Owner, Url, StorageQuota. This lists all personal sites in the tenant. Compare the output with your list of migrated users. Any user missing from this output did not have their site provisioned.
6. Check the storage quotas report in the OneDrive admin center
   Open the Microsoft 365 admin center. Go to Admin centers > OneDrive. In the OneDrive admin center, select Storage under the left navigation. The list shows all users with a provisioned OneDrive site. If a user is still missing, return to step 4 and provision that user individually.

Alternative Method: Force Provisioning by Simulating User Sign-In

If you cannot use PowerShell, you can ask each migrated user to sign in to OneDrive at onedrive.com. This triggers auto-provisioning. However, for a large number of users, this method is time-consuming and unreliable. Use PowerShell for bulk provisioning instead.

If Users Remain Missing After Provisioning

The user does not have an Exchange Online license assigned

OneDrive site provisioning requires the user to have an Exchange Online license in addition to the OneDrive license. The Exchange license provides the user’s mailbox, which is used to create the personal site identifier. If the user lacks an Exchange license, assign one in the Microsoft 365 admin center under Users > Active users > Licenses and apps. After assigning the license, run the Request-SPOPersonalSite cmdlet again for that user.

The user’s UPN has changed after migration

If the user’s user principal name was modified during migration, the OneDrive site URL may not match the new UPN. The storage quotas report uses the UPN to identify users. To fix this, run Set-SPOUser -Site https://[tenant]-my.sharepoint.com/personal/[old_upn] -LoginName [new_upn]. This updates the site to use the new UPN. After the update, the user appears in the storage quotas report.

The tenant has reached the site collection limit

Each Microsoft 365 tenant has a default limit of one million site collections. If you have migrated a very large number of users, you may have reached this limit. Check the current site count by running (Get-SPOSite -Limit ALL).Count. If the count is near one million, contact Microsoft Support to request a limit increase. After the limit is raised, provision the remaining users.

OneDrive Site Provisioning Methods: Comparison

Item	Auto-Provisioning (User Sign-In)	PowerShell Bulk Provisioning
Description	Site created when user signs in to OneDrive	Site created using Request-SPOPersonalSite cmdlet
Best for	Small groups of fewer than 10 users	Large migrations with 50 or more users
Time required	Depends on when each user signs in	15 to 30 minutes for up to 200 users
Admin effort	Low after migration	Medium: requires PowerShell knowledge
User impact	User must sign in manually	No user action required
Reliability	Low: users may forget to sign in	High: all sites created at once

After you complete the checklist, every migrated user should have a provisioned OneDrive site and appear in the storage quotas report. Run the Get-SPOSite cmdlet weekly during the migration period to catch any users who were missed. If you encounter users who still do not appear, check their license assignment and UPN consistency. The OneDrive admin center storage report will then show accurate storage usage for all users.