PowerShell - Discover usernames from lastname, firstname in a csv path
- Jon Boyette
- Jan 10, 2022
- 1 min read
Save as a .ps1, When ran asks for path of populated CSV. then Outputs Usernames to C:\Temp\LastNamesToSAM.csv
$a = Read-Host "Enter CSV path with lastname, firstname in Column A"
$users = Get-Content $a
$Results = ForEach ($user in $users)
{
Get-ADUser -LDAPFilter "(anr=$user)" -Properties Name,SamAccountName | select Name,SamAccountName
}
$Results | Export-CSV -path C:\Temp\LastNamesToSAM.csv -NoTypeInformation
Comments