OneDrive for Business storage quotas troubleshooting for offboarding workflows: show missing users

When running an offboarding workflow for a departing employee, you may find that the user’s OneDrive for Business account does not appear in the storage quota report or in the list of managed sites. This typically happens because the user has not yet accessed OneDrive, the site has been deleted or put on hold, or the tenant’s site provisioning policy has changed. This article explains the root causes of missing OneDrive sites during offboarding and provides step-by-step fixes to locate and reclaim storage.

Why OneDrive Sites Go Missing During Offboarding Workflows

OneDrive for Business sites are provisioned the first time a user signs in to OneDrive or saves a file to their personal library. If a user never accessed OneDrive, no site exists in the tenant’s site collection list. In an offboarding context, this means the user’s OneDrive will not appear in storage quota reports or in the admin center’s storage page.

Another common cause is that the site was deleted as part of a previous offboarding or retention policy. When a OneDrive site is deleted, it moves to the first-stage recycle bin (93 days) then to the second-stage recycle bin (additional 93 days) before permanent removal. During this period, the site is hidden from standard admin views but still occupies storage quota.

A third cause is that the user’s license was removed before the offboarding workflow ran. Without a valid SharePoint Online license, the OneDrive site becomes inaccessible and is not returned in standard site queries. However, the site data remains in the tenant’s storage pool and can be reclaimed if the license is restored within 30 days.

Site Provisioning Delay

Even if a user has accessed OneDrive, there can be a delay of up to 24 hours before the site appears in the SharePoint admin center or in PowerShell queries. This delay is by design to reduce load on the provisioning service. Offboarding workflows that run immediately after a user’s first sign-in may not detect the site.

Tenant-Level Site Quotas

If your tenant has a storage quota that is nearly full, OneDrive may stop provisioning new sites automatically. In this case, users who attempt to access OneDrive will see an error, and no site will be created. The missing user is therefore not an offboarding issue but a capacity problem.

Steps to Locate and Reclaim Storage for Missing OneDrive Sites

Follow these steps in order. Start with the simplest method and escalate to PowerShell only if the site is not visible in the admin center.

1. Check the Microsoft 365 admin center > Active users
   Go to Microsoft 365 admin center > Users > Active users. Select the user in question. Click the OneDrive tab. If a site exists, you will see links to manage storage, delete the site, or transfer files. If the tab shows “No OneDrive site found,” the user has never accessed OneDrive or the site was deleted.
2. Run Get-SPOSite with the IncludePersonalSite parameter
   Open the SharePoint Online Management Shell as an administrator. Connect to your tenant with Connect-SPOService -Url https://contoso-admin.sharepoint.com. Then run Get-SPOSite -IncludePersonalSite $true -Filter "Url -like '-myfiles.sharepoint.com/personal/'" | Where-Object {$_.Owner -eq "user@contoso.com"}. This returns OneDrive sites even if they are in the recycle bin or unlicensed. If the command returns no results, the site has been permanently deleted.
3. Restore a deleted OneDrive site from the recycle bin
   If the site is in the first-stage recycle bin (deleted within 93 days), run Restore-SPODeletedSite -Identity https://contoso-myfiles.sharepoint.com/personal/user_contoso_com. For second-stage recycle bin, use Get-SPODeletedSite -IncludePersonalSite $true | Restore-SPODeletedSite. After restoration, the site will appear in the admin center within 15 minutes.
4. Reapply a SharePoint Online license to recover the site
   If the user’s license was removed, go to Microsoft 365 admin center > Billing > Licenses. Assign a SharePoint Online plan (Plan 1 or Plan 2) to the user. Wait up to 30 minutes, then run the PowerShell command from step 2 again. The site should reappear.
5. Check tenant storage quota and site provisioning status
   Run Get-SPOTenant | Select-Object StorageQuota, StorageQuotaAllocated. If StorageQuotaAllocated is close to StorageQuota, increase the quota or delete unused sites. Then run Set-SPOTenant -DisablePersonalSiteProvision $false to ensure new sites can be created.
6. Manually trigger OneDrive provisioning for the user
   If the user never accessed OneDrive, you can force provisioning by sending a direct sign-in link: https://contoso-myfiles.sharepoint.com/?user=user@contoso.com. Have the user sign in with their credentials. After 15 minutes, the site will be created and will appear in storage reports.

If OneDrive Still Does Not Appear After These Steps

Get-SPOSite returns no result for a user who has accessed OneDrive

This can happen if the user’s site URL changed due to a rename or domain migration. Run Get-SPOSite -IncludePersonalSite $true -Filter "Url -like 'user'" to search by partial username. If the user’s display name was changed, the site URL may contain the old name.

If the site URL is still not found, use the Microsoft Graph API to enumerate all OneDrive sites: GET https://graph.microsoft.com/v1.0/users/user@contoso.com/drive. A 404 response confirms that no site exists.

Storage quota report shows zero bytes for a user

This indicates the site exists but has no files. It can occur when the user’s OneDrive was provisioned but never used. The site still consumes a small amount of storage (approximately 5 MB for the site structure). To reclaim that storage, delete the site from the admin center or via PowerShell: Remove-SPOSite -Identity https://contoso-myfiles.sharepoint.com/personal/user_contoso_com.

Offboarding script fails because the site is on hold

If the site has a litigation hold or retention policy applied, Remove-SPOSite will fail. Check holds with Get-SPOSite -Identity | Select-Object LockState. If the lock state is ReadOnly or NoAccess, remove the hold from the Microsoft Purview compliance portal before proceeding with offboarding.

OneDrive Site Visibility in Admin Tools: Comparison

Item	Microsoft 365 admin center (Active users > OneDrive tab)	SharePoint Online Management Shell (Get-SPOSite -IncludePersonalSite $true)
Shows uninitialized users	No	No
Shows deleted sites in recycle bin	No	Yes
Shows unlicensed users	No	Yes (within 30 days of license removal)
Shows sites with holds	Yes	Yes
Shows storage quota used	Yes	Yes
Requires admin role	Global admin or SharePoint admin	SharePoint admin

The PowerShell method is the only way to recover deleted or unlicensed OneDrive sites during offboarding. Always run Get-SPOSite -IncludePersonalSite $true before concluding that a user’s OneDrive is missing.

You can now locate any missing OneDrive site during offboarding using either the admin center or PowerShell. For next steps, consider setting a storage quota alert in the SharePoint admin center to detect sites approaching the tenant limit. A concrete advanced tip: automate the Get-SPOSite -IncludePersonalSite $true query in a scheduled PowerShell script that emails the list of uninitialized users to your IT team weekly.