During a tenant-to-tenant migration, administrators often run storage quota reports to verify that OneDrive for Business accounts have moved correctly. A common problem is that the report shows fewer users than expected, with some accounts missing entirely. This can happen when the migration tool does not fully replicate the user’s OneDrive site or when the user’s license assignment is incomplete in the target tenant. This article explains why users go missing from storage quota reports and provides step-by-step fixes to locate and restore them.
Key Takeaways: Restoring Missing OneDrive Users in Tenant Migrations
- Microsoft 365 admin center > Users > Active users: Verify that each missing user has a OneDrive for Business license assigned before checking storage quotas.
- SharePoint Online Management Shell > Get-SPOSite: Use this PowerShell cmdlet to list all OneDrive sites and confirm the missing site URLs.
- Microsoft 365 admin center > Reports > Usage > OneDrive: Run a detailed storage report to compare expected vs actual users and identify gaps.
Why OneDrive Users Disappear From Storage Quota Reports After Migration
When you migrate users from one Microsoft 365 tenant to another, the migration process must create a OneDrive site for each user in the target tenant. If the site creation fails or is skipped, the user will not appear in storage quota reports. The root cause is often one of three things:
Incomplete License Assignment
Each user must have a OneDrive for Business license assigned in the target tenant before migration. If the license is missing or the user is in a grace period, the OneDrive site provisioning is blocked. The storage quota report only shows users with active, provisioned sites.
Migration Tool Skipped the User
Some migration tools, such as Microsoft 365 Migration Manager or third-party tools like ShareGate, can skip a user if the source site is locked, empty, or corrupted. The tool reports a success but does not create the target site. The user then has no OneDrive to report.
Site URL Conflict or Naming Collision
If a user in the target tenant already has a OneDrive site with the same URL pattern, the migration tool may fail to create a new site. The conflict prevents the site from appearing in quota reports. This is common when the target tenant previously had a user with the same email alias.
Steps to Locate and Restore Missing OneDrive Users
Follow these steps in order to find which users are missing and restore their OneDrive sites. You will need global admin or SharePoint admin permissions in both source and target tenants.
- Verify license assignment in the target tenant
Sign in to the Microsoft 365 admin center. Go to Users > Active users. Select a missing user and check the Licenses and apps tab. Ensure OneDrive for Business is toggled on. If it is off, assign the license and wait 30 minutes for provisioning to complete. - Run a SharePoint Online Management Shell report
Open the SharePoint Online Management Shell as an administrator. Connect to your target tenant withConnect-SPOService -Url https://[tenant]-admin.sharepoint.com. RunGet-SPOSite -IncludePersonalSite $true -Filter "Url -like '-my.sharepoint.com/personal/'"to list all OneDrive sites. Export the results to a CSV file. Compare this list against your migration manifest to identify missing site URLs. - Check the migration tool logs
Open your migration tool’s report or log file. Look for entries with status Skipped, Failed, or Not Processed. Common error codes include SiteAlreadyExists, LicenseNotFound, and UserNotFound. Record the affected user principal names (UPNs). - Use the Microsoft 365 Usage Reports
In the Microsoft 365 admin center, go to Reports > Usage > OneDrive. Click View more under the Files chart. Export the report to Excel. The report shows every user with an active OneDrive site. Compare this list to your expected user list. Any user not in the report is missing a provisioned site. - Manually provision the missing OneDrive site
If a user has a license but no site, you can force provisioning. In the SharePoint admin center, go to Active sites. Click Create and select OneDrive site. Enter the user’s UPN and set a storage quota. This creates the site immediately and the user will appear in quota reports within 15 minutes. - Resolve naming conflicts
If the error is SiteAlreadyExists, the target tenant already has a OneDrive site for that user. To resolve, go to Active sites in the SharePoint admin center. Find the existing site and delete it or rename it. Then rerun the migration step for that user only. After the site is created, runSet-SPOSite -Identity [siteURL] -StorageQuota [newQuota]to adjust the quota.
If Users Still Do Not Appear After the Main Fix
Even after following the steps above, some users may remain missing. Here are the most common residual issues and how to resolve them.
OneDrive Shows a Red X on Shared Office Files
A red X icon on Office files in File Explorer indicates a sync conflict or a broken link to the user’s OneDrive. This usually happens when the user’s site URL changed during migration. Open OneDrive settings, go to Account > Unlink this PC. Sign out, sign back in with the new target tenant credentials, and files will sync to the correct site.
Storage Quota Shows 0 GB for a Provisioned User
If the user appears in the quota report but shows 0 GB used, the site may be empty or the migration did not copy files. Check the migration logs for that user. If the site is empty, rerun the file copy step for that user only. After files are uploaded, run Get-SPOSite -Identity [siteURL] | Select StorageUsageCurrent to confirm the value updates.
User Cannot Access OneDrive After Migration
The user may see a “We can’t find your OneDrive” error when signing in. This occurs when the user’s UPN changed during migration but the OneDrive site URL still uses the old UPN. In the SharePoint admin center, go to Active sites, find the user’s site, and edit the Primary admin field to match the new UPN. The site will then appear in the user’s OneDrive portal.
Storage Quota Reports Before and After Migration: Key Differences
| Item | Before Migration (Source Tenant) | After Migration (Target Tenant) |
|---|---|---|
| User count | Full list of licensed users with sites | May be lower if provisioning failed |
| Storage used | Actual file usage per user | May show 0 GB if files not copied |
| Site URL pattern | https://source-my.sharepoint.com/personal/ | https://target-my.sharepoint.com/personal/ |
| License dependency | OneDrive license already assigned | License must be assigned in target tenant |
| Report generation tool | SharePoint admin center or PowerShell | Same tools but must connect to target tenant |
After completing the steps above, you can generate an accurate storage quota report that includes all migrated users. Run the PowerShell command Get-SPOSite -IncludePersonalSite $true | Export-Csv C:\OneDriveReport.csv weekly for the first month to catch any delayed provisioning. If a user remains missing after 48 hours, open a support ticket with Microsoft and provide the migration logs and the user’s UPN. This ensures the migration is fully auditable and all users have their correct storage quota.