I just can find one by one Get-aduser -filter 'Name -like " displayname " ' -Properties * | Format-table Name,SamAccountName,EmailAddress -A

How to output many people's SamAccountName in batch by powershell

Accepted answer

Ian Xue (Shanghai Wicresoft Co., Ltd.) 30,381 Microsoft Vendor

Hi,

Suppose you have an array of displaynames $displaynames, then you can do something like the following

$displaynames = ’dn1‘,'dn2','dn3'  
foreach($displayname in $displaynames)  
{  
    Get-ADUser -Filter {displayname -eq $displayname} -Properties EmailAddress | Format-table Name,SamAccountName,EmailAddress -AutoSize  
}

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Jacky Guo 21 Reputation points

2021-03-16T15:17:41.427+00:00

Thank you so much! BTW,If I create a CSV file of all the displayname, how to do the loop from the CSV file.

Rich Matheisen 45,096

Try this (assuming the CSV has a column named "displayname"):

foreach($displayname in (Import-CSV x:\file.csv).displayname)
{
     Get-ADUser -Filter {displayname -eq $_} -Properties EmailAddress | Format-table Name,SamAccountName,EmailAddress -AutoSize
}

Jacky Guo 21

I do not know why it is error.

Get-ADUser : Variable: '_' found in expression: $_ is not defined.
At line:3 char:7
+       Get-ADUser -Filter {displayname -eq $_} -Properties EmailAddres ...
+       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Comm
   ands.GetADUser

Jacky Guo 21

Changhe $_ to $displayname will be OK.

 foreach($displayname in (Import-CSV c:\file.csv).displayname)
 {
      Get-ADUser -Filter {displayname -eq $displayname} -Properties EmailAddress | Format-table Name,SamAccountName,EmailAddress -AutoSize
 }

Rich Matheisen 45,096 Reputation points

2021-03-17T02:44:23.467+00:00
Sorry. I'm so used to using pipes that I forgot that I was using a "foreach" followed by an expression -- and that doesn't use the pipeline.

Here's what I shold have written:

Import-Csv x:\file.csv | ForEach-Object { Get-ADUser -Filter { displayname -eq $_.displayname } -Properties EmailAddress | Format-Table Name, SamAccountName, EmailAddress -AutoSize }

Jacky Guo 21

XD , still error

Get-ADUser : Property: 'displayname' not found in object of type: 'System.Management.Automation.PSCustomObject'.
At line:2 char:10
+          Get-ADUser -Filter { displayname -eq $_.displayname } -Prope ...
+          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

Get-ADUser : Property: 'displayname' not found in object of type: 'System.Management.Automation.PSCustomObject'.

Jacky Guo 21

BTW,IF I want to divide the output file by comma. what should i do.

foreach($displayname in (Import-CSV c:\file.csv).displayname)
  {
Get-ADUser -Filter {displayname -eq $displayname} -Properties * | Format-table Name,SamAccountName,EmailAddress -AutoSize -HideTableHeaders | Out-File -NoClobber -Append -FilePath d:\1.txt
}

Jacky Guo 21

thank you so much！ already resolved

$output = foreach($displayname in (Import-CSV c:\file.csv).displayname)
 {
  Get-ADUser -Filter {displayname -eq $displayname} -Properties * | select Name,SamAccountName,EmailAddress,title
}

$output | Export-CSV D:\1.csv -Append -encoding UTF8

How to output many people's SamAccountName in batch by powershell

0 additional answers