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

Question

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

Jacky Guo 21

I just can find one by one

Get-aduser -filter 'Name -like "displayname" ' -Properties * | Format-table Name,SamAccountName,EmailAddress -A

Anonymous

2021-03-16T10:09:51.577+00:00

What are the names of the AD users you want to get? Your command only gets the users with the names containing “displayname”.
Jacky Guo 21 Reputation points

2021-03-16T10:36:10.617+00:00

I need to query the information of more than 200 people only have there displayname. i mean the displayname is a field of AD.
Jacky Guo 21 Reputation points

2021-03-16T10:37:14.55+00:00

BTW Thanks for your reply

Accepted answer

0 additional answers

Your answer

Anonymous

2021-03-16T10:09:51.577+00:00

What are the names of the AD users you want to get? Your command only gets the users with the names containing “displayname”.
Jacky Guo 21 Reputation points

2021-03-16T10:36:10.617+00:00

I need to query the information of more than 200 people only have there displayname. i mean the displayname is a field of AD.
Jacky Guo 21 Reputation points

2021-03-16T10:37:14.55+00:00

BTW Thanks for your reply

Answer 1

Anonymous

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 47,901

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 47,901 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

Share via

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

0 additional answers

Your answer