PowerShell script to get a list with user and their OneDrive Url information (O365)

 

Here is the script to get a list with user and their OneDrive Url information.

·       Install PnP module first:

Install-Module PnP.PowerShell

Replace the account and tenant information in the following script and run the following command:

$creds = (New - Object System.Management.Automation.PSCredential "XXX@XXX.onmicrosoft.com", (ConvertTo - SecureString "PASSWORD" - AsPlainText - Force)) Connect - PnPOnline - Url “https: //XXX.sharepoint.com” -Credentials $creds $userList = get - PnpUser $results = New - Object System.Collections.ArrayList foreach($user in $userList) {     if ([string]::IsNullOrWhiteSpace($user.Email)) {         continue     }       $userInfo = Get - PnPUserProfileProperty - Account $user.Email       $item = New - Object System.Object     $item | Add - Member - MemberType NoteProperty - Name "Email" - Value $user.Email     $item | Add - Member - MemberType NoteProperty - Name "OneDriveUrl" - Value $userInfo.PersonalUrl     $results.Add($item) | Out - Null   } #Output result $results | Export-CSV 'C:\Users\XXX\XXX\Desktop\Url Details.csv' -Force