Get-aduser with filter from txt file

Question

Hello
please help me to fix this case:
i have text file content all displayname with header displayname, i want to excute this one:
import-module ActiveDirectory
$users= Get-Content c:\scripts\displaynames.txt

foreach ($user in $users){

get-aduser -filter {DisplayName eq $_.displayname} | Select-Object -Property samaccountname,displayname

}

i get error :
get-aduser : Erreur lors de l’analyse de la requête : « DisplayName eq $*.displayname » Message d’erreur : « syntax error » à la position : « 13 ».
Au caractère Ligne:5 : 1

• get-aduser -filter {DisplayName eq $*.displayname} | Select-Object - ...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : ParserError: (:) [Get-ADUser], ADFilterParsingException
• FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADFilterParsingException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

get-aduser : Erreur lors de l’analyse de la requête : « DisplayName eq $*.displayname » Message d’erreur : « syntax error » à la position : « 13 ».
Au caractère Ligne:5 : 1

• get-aduser -filter {DisplayName eq $*.displayname} | Select-Object - ...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : ParserError: (:) [Get-ADUser], ADFilterParsingException
• FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADFilterParsingException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

Answer 1

Hi @HMIMED The king ,

this script is working with the text file without any problems here:

Textfile Content:

Jon Doe  
Abraham Linkon  
Peter Pan  
John Wayne  

Script:

Import-Module ActiveDirectory  
Get-Content C:\Scripts\displaynames.txt |  
ForEach-Object {  
    $user = $_.Trim()  
    Get-ADUser -Filter "DisplayName -eq '$user'" -Properties DisplayName |   
    Select-Object -Property SamAccountName, DisplayName  
}  

Result:

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi @HMIMED The king ,

if you use Get-Content c:\scripts\displaynames.txt the txt file contains just the DisplayName of each user in each row and now additional columns?

If "yes" please try this:

Import-Module ActiveDirectory  
$users = Get-Content c:\scripts\displaynames.txt  
foreach ($user in $users) {  
    Get-ADUser -Filter "DisplayName -eq '$user'" -Properties DisplayName | Select-Object -Property SamAccountName, DisplayName  
}  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 3

Hi @HMIMED The king

Cab you share please your .txt file. how to fill data into .TXT file

Answer 4

hi thanks for reply
bu when Import-Module ActiveDirectory
$users = Get-Content c:\scripts\displaynames.txt
foreach ($user in $users) {
Get-ADUser -Filter "DisplayName -eq '$user'" -Properties DisplayName | Select-Object -Property SamAccountName, DisplayName
}

it send the same line of powershell et no result of AD

i think the problem is on eq $user same with -like how i can fix it.

thanks

Answer 5

hi thanks for reply
bu when Import-Module ActiveDirectory
$users = Get-Content c:\scripts\displaynames.txt
foreach ($user in $users) {
Get-ADUser -Filter "DisplayName -eq '$user'" -Properties DisplayName | Select-Object -Property SamAccountName, DisplayName
}

it send the same line of powershell et no result of AD

i think the problem is on eq $user same with -like how i can fix it.

thanks