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