Domino LDAP using Powershell

Sometimes you need to query your Domino server to get a username, a name, an email, etc. In my case I need to get the username (FirstName LastName/Domain) using the userid (username). Yeah that's confusing...

I need this to be able to automatically configure the Lotus Notes client as we are deploying Windows 7. So with that information I will automatically create the text config file that goes inside the notes.ini file.

So let's see how to do it.

#Create the connection

$Connection = New-Object -Com "ADODB.Connection"
$Connection.Provider = "ADsDSOObject"
$Connection.Open("Active Directory Provider")
$Command = New-Object -Com "ADODB.Command"
$Command.ActiveConnection = $Connection

#Create the Query

$Query = "SELECT displayname, uid FROM " + `
   "'LDAP://ServerName" + `
   "'WHERE uid='$($env:username)'"

#Execute the command
  
$Command.CommandText = $Query
$Execution = $Command.Execute()
$Execution.movefirst()
$Execution.fields | ? {$_.name -eq "DisplayName"} | select -ExpandProperty Value

That's it.
If you want to get all the information you can change the WHERE line to:

"'WHERE ObjectClass='inetOrgPerson'"

And loop until the end.

do{$Execution.fields; $Execution.movenext()}
while(!$Execution.EOF)