Get all OneDrive sites with PnP PowerShell

If you would like to get all the OneDrive sites we can use PnP Powershell. See below PowerShell script.

$siteUrl = "https://modernizeIt-admin.sharepoint.com"
$clientId = "someGuid"
$outputPath = "C:\Temp\OneDrive.csv"

Connect-PnPOnline  -Url $siteUrl -ClientId $clientId -Interactive

Write-Host "Start searching all OneDrives"
$oneDriveSites = Get-PnPTenantSite -IncludeOneDriveSites -Filter "Url -like '-my.sharepoint.com/personal/'"
Write-Host "Finished searching all OneDrives"

Write-Host "Write output to a csv file"
$oneDriveSites | Export-Csv $outputPath -NoTypeInformation