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 ,

instead of equals ( -eq ) you cann try -like as well:

Get-ADUser -Filter "DisplayName -like '$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

Are you sure that the file containing the display names has no leading or trailing space characters? Can you attach a file containing, say, the first few lines of that file?

In the meantime, try trimming the data befor you use it:

Get-Content c:\scripts\displaynames.txt |  
    ForEach-Object {  
        $user = $_.Trim()  
        Get-ADUser -Filter "DisplayName -eq '$user'" |   
            Select-Object -Property samaccountname, displayname  
    }  

Keep in mind that the contents of the DisplayName property is not guaranteed to be unique in the AD.

Answer 4

256830-displaynames.txt