Unprovisioned One Drives in tenant and empty one drives

Brass Contributor

Hi, as an M365 admin I'm trying to find out whether there is a way you can find out...


(1)total user's OneDrive that are NOT provisioned in the M365 Tenant


(2) Which users have no files/data/zero storage in their One Drive's


appreciate any guidance!

2 Replies

Hi @Kevin Egan,

you can use PowerShell to identify your two specific wishes regarding OneDrive:

1. Unprovisioned OneDrive Accounts:

These are OneDrive accounts for users who have a license but haven't set up or used their OneDrive storage yet. To find these users, you can follow these steps:

a. Connect to Microsoft 365 PowerShell.

b. Run a script that checks for licensed users who haven't signed in to OneDrive. These users are the ones with unprovisioned OneDrive accounts.

c. The script will give you a list of such users, including their display names and user principal names.

# Connect to Microsoft 365 PowerShell

# Get a list of licensed users who haven't signed in to OneDrive
$unprovisionedUsers = Get-MsolUser -All | Where-Object {($_.IsLicensed -eq $true) -and ($_.LastSignInDate -eq $null)}

# Display the list of unprovisioned users
$unprovisionedUsers | Select-Object DisplayName, UserPrincipalName


2. Users with Empty OneDrive Storage:

These are users who have OneDrive accounts but haven't stored any files or data in them. To identify these users, you can use the SharePoint Online Management Shell (Download SharePoint Online Management Shell from Official Microsoft Download Center:(

a. Connect to SharePoint Online using PowerShell in SharePonint Online Management Shell opened as an administrator.

b. Run a script that checks for OneDrive accounts with no stored data.

c. The script will provide you with a list of users who fall into this category, showing their names and OneDrive URLs.

# Connect to SharePoint Online
Connect-SPOService -url https://yourdomain-admin.sharepoint.com

# Get a list of users with empty OneDrive storage
$emptyOneDriveUsers = Get-SPOSite -IncludePersonalSite $true | Where-Object { $_.StorageUsageCurrent -eq 0 }

# Display the list of users with empty OneDrive storage
$emptyOneDriveUsers | Select-Object Title, Url


Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic

@LeonPavesic Thank you very much, I tried the first one and it gave me a list of all licensed Provisioned users and unprovisioned users ? wonder if powershell needs tweaking?


the second one worked fine and gave me a list of all licensed users with zero storage :smile: