Tuesday, 1 October 2013

Matching users from a CSV against Active Directory using PowerShell

I am trying to match users I have in a CSV with two columns (givenName and sn) against active directory.


The following script produces no output at all, not even an error:
Import-Csv input.csv | foreach {Get-ADUser -LDAPFilter "(&(givenName=$_.givenName)(sn=$_.sn))"}


The components work individually:

  • Import-Csv input.csv
  • Get-ADUser -LDAPFilter "(&(givenName=karl)(sn=foley))"
  • Import-Csv input.csv | foreach {write-host $_.givenName,$_.sn}



I've also verified that there are no extra characters in the csv using:
Import-Csv input.csv | foreach {write-host $_.givenName,$_.givenName.length,$_.sn,$_.sn.length}


What am I doing wrong please?