Unprovisioned One Drives in tenant and empty one drives

Hi KEGAN1975,

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
Connect-MsolService

# 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