Active Directory Lookup

Hi all,

Im trying to do a active directory lookup using powershell to find the users email address from the sAMAccountName's listed in a array or text file.  At the moment I have got this far but not sure if its the best way and this way gets me more than just the emailaddress@domain.com

###########################################################

cls

$SAMName = "users_sam_id"

  $Searcher = New-Object DirectoryServices.DirectorySearcher
  $Searcher.Searchroot ="LDAP://OU=XXXXXX,OU=XXXXX),DC=XXXXX,DC=XXX"
  $searcher.filter = "(&(objectClass=user)(sAMAccountName= $SAMName))"
                                                                                                                   
  $userlist = "mail"
  $userlist | foreach {[void]$Searcher.Propertiestoload.Add($_)}
 
  $userlist= $searcher.findall()
 
  $results = $searcher.findall()
   
foreach ($result in $results){$result.properties}

$result.properties |ft value | out-file searchemail.txt

#############################################################

This works except it gives me more than just the emailaddress@domain.com and doesnt read the sAMAccountName's from a text file.

 Any help on this would be great.

Here's one way you could handle this:

$Searcher = New-Object DirectoryServices.DirectorySearcher
$Searcher.Searchroot ="LDAP://DC=company,DC=local"
get-content sams.txt | % {
  write $_
  $searcher.filter = "(&(objectClass=user)(sAMAccountName= $_))"
  $searcher.FindOne().Properties.mail
}

Because you are filtering on the Samaccountname you should only get one match so you only need to find the first match.  If you can use the free Quest AD cmdlets this can be done even easier:

cat sams.txt | % {get-qaduser $_ | select dn,mail}

Thanks for your reply that was very useful,
 
I am now trying to get the results output to a varible to use later when sending a email in the script, at the moment I can output the results to a text file by doing
 
$searcher.FindOne().Properties.mail | Out-File -filepath "C:\ADScripts\AD Lookup\lookupresult.txt"  -append
 
The problem is this wont work if I change it to out-string or outvariable.  Also without using the -append on the text file it only stores the email address of the sam last checked.
 
Hope this makes sense.
 
Regards
Marcus

Save your results to a variable, then you can use the variable to send output to a file and do whatever else you want.


$Searcher = New-Object DirectoryServices.DirectorySearcher
$Searcher.Searchroot ="LDAP://DC=company,DC=local"
get-content sams.txt | % {
write $_
$searcher.filter = "(&(objectClass=user)(sAMAccountName= $_))"
$results+=$searcher.FindOne().Properties.mail
}

The variable $results can now be piped to Out-file and you can use it for other things as well.