Migrating H drives to One Drive - Create csv

TJCooper440 Ah, no problem. Changed it again, a bit more compact and also using only one Get-Aduser like AndySvints mentioned 🙂 

$Users = Get-ADUser -Searchbase "OU=users,OU=Corp,DC=test,DC=local" -Filter * -Properties HomeDirectory, SamAccountName
$TotalOutput = @()

Foreach ($User in $Users) {
    $OneDrivePath = "\\test\test\" + $user.SamAccountName + "_constoso_loc"
    $Output = New-Object -Typename psobject	
    $Output | Add-Member -MemberType NoteProperty -Name HomeDirectory -Value $User.HomeDirectory
    $Output | Add-Member -MemberType NoteProperty -Name OneDrivePath -Value $OneDrivePath
    $Totaloutput += $Output
}

$Totaloutput | Export-csv "C:\temp\test.csv" -NoTypeInformation

Output:

"HomeDirectory","OneDrivePath"
"\\w2k22dc\home$\test.user1","\\test\test\test.user1_constoso_loc"
"\\w2k22dc\home$\test.user2","\\test\test\test.user2_constoso_loc"
"\\w2k22dc\home$\test.user3","\\test\test\test.user3_constoso_loc"