PS Search filter not recognized Get-AdUser

Newbie 0

I am getting an error with the script, anyone see any issues obvious?

Error Message:

WARNING: Failed to update 
Get-ADUser : The search filter cannot be recognized
At H:\updatelocale.ps1:4 char:15
+ ...   $ADUser = Get-ADUser -Filter "displayName -eq '$($user.displayName) ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-ADUser], ADException
    + FullyQualifiedErrorId : ActiveDirectoryServer:8254,Microsoft.ActiveDirectory.Management.Commands.GetADUser

IMPORT-MODULE ActiveDirectory
Import-Csv -Delimiter ";" -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter "displayName -eq '$($user.displayName)'" -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser -msExchUsageLocation $user.msExchUsageLocation
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }
}


CSV Entries:
displayName,msExchUsageLocation
john doe,US

3 answers

H Risbud 251 Reputation points

2023-04-04T17:40:51.25+00:00

Try

$ADUser = Get-ADUser -Filter {displayName -eq '$($user.displayName)'} -Properties msExchUsageLocation or $ADUser = Get-AdUser -Filter * -Properties * | Where {$_.DisplayName -eq '$($user.displayName)'}
Please sign in to rate this answer.
Newbie 0 Reputation points

2023-04-04T22:10:50.72+00:00

I tried the first line with the delimiter and got farther, now I just get a warning, I am wondering if the value is not set if I need to do a replace command? here is the error:

WARNING: Failed to update john doe

Newbie 0 Reputation points

2023-04-04T22:17:11.15+00:00

Also the second command you suggest I assume is loading all user properties before adding the value? I noticed that took longer to return the same "Warning: Failed to update John Doe" I am stumped this doesn't seem like it should be hard to update one attribute that doesn't have a value set currently.

Newbie 0 Reputation points

2023-04-04T22:35:41.24+00:00

I also confirmed this command works to add the value

Set-ADUser -identity john.doe -Add @{msExchUsageLocation = "US"}

H Risbud 251 Reputation points

2023-04-04T22:36:57.5533333+00:00

Yes second command will load all properties resulting slow process
Two changes need to be done

Change delimiter ';' to ',' which is in your CSV sample file --> Import-Csv -Delimiter "," -Path H:\test.csv

To get AD User change this $ADUser = Get-ADUser -Filter {displayName -eq '$($_.displayName)'} -Properties msExchUsageLocation See the corrected code as answer below
Sign in to comment
Rich Matheisen 45,906 Reputation points

2023-04-04T18:04:00.8766667+00:00

The Import-CSV specifies that the delimiter is a semicolon, but the CSV that you posted uses a comma as the delimiter. Either change the Import-CSV by removing the '-Delimiter ";"' altogether, or changing it to '-Delimiter ","'.
Please sign in to rate this answer.
Newbie 0 Reputation points

2023-04-04T22:08:30.5866667+00:00

thanks, this got me a bit farther
Sign in to comment

H Risbud 251

This code will solve this issue

Import-Module ActiveDirectory
Import-Csv -Delimiter "," -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter {displayName -eq '$($_.displayName)'} -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser -msExchUsageLocation $user.msExchUsageLocation
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }
}

Rich Matheisen 45,906 Reputation points

2023-04-04T23:01:56.5266667+00:00

Actually, that shouldn't work. You're using "$ADUser" as the identity, but $ADUser is a user object, not an identity. Use $ADUser.distinguishedName instead.

Newbie 0

Hmm that didn't work, is this what you meant?


Import-Module ActiveDirectory
Import-Csv -Delimiter "," -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter {displayName -eq '$($_.displayName)'} -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser.distinguishedName -msExchUsageLocation $user.msExchUsageLocation
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }

Rich Matheisen 45,906 Reputation points

2023-04-05T01:41:48.1+00:00
Yes, but what did you mean by "it didn't work?" Try using a quoted string for the filter instead of the scriptblock:

-Filter "displayname -eq '$($_.displayname)'"

The way your code is written the "Failed to update" is misleading. It should say Write-Warning "Failed to find '$($_.displayname)'"

If the Set-ADUser failed it would have generated an exception, not display your "Failed to . . ." message.

Newbie 0

There error was "Warning Failed to update John Doe" With the quoted string block, the one error I got is likely due to no name on that object, so I think the error is updating the attribute:

Import-Module ActiveDirectory
Import-Csv -Delimiter "," -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter "displayName -eq '$($_.displayName)'" -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser.distinguishedName -msExchUsageLocation $user.msExchUsageLocation
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }
}


Set-ADUser : A parameter cannot be found that matches parameter name 'msExchUsageLocation'.
At H:\updatelocale.ps1:7 char:56
+ ... User -Identity $ADUser.distinguishedName -msExchUsageLocation $user.m ...
+                                              ~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Set-ADUser], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.ActiveDirectory.Management.Commands.SetADUser

Newbie 0

With the script block there is no error, but I do get "Warning: Failed to Update John Doe" Perhaps the attribute which is not set requires a clear before an add? I don't know.

Import-Module ActiveDirectory
Import-Csv -Delimiter "," -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter {displayName -eq '$($_.displayName)'} -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser.distinguishedName -msExchUsageLocation $user.msExchUsageLocation
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }
}

H Risbud 251

Use this try Set-ADUser -Identity $ADUser.distinguishedName -msExchUsageLocation '$($_.msExchUsageLocation)' or $ADUser | Set-ADUser -Replace @{msExchUsageLocation="$($_.msExchUsageLocation)"}

Import-Module ActiveDirectory
Import-Csv -Delimiter "," -Path H:\test.csv | Foreach {
    # Find user
    $ADUser = Get-ADUser -Filter "displayName -eq '$($_.displayName)'" -Properties msExchUsageLocation

    if ($ADUser){
        Set-ADUser -Identity $ADUser.distinguishedName -msExchUsageLocation '$($_.msExchUsageLocation)'
    }else{
        Write-Warning ("Failed to update " + $($_.displayName))
    }
}

Rich Matheisen 45,906 Reputation points

2023-04-05T18:33:47.9066667+00:00

The error is pretty clear: The Set-ADUser doesn't have a parameter named "-msExchUsageLocation".

You want to use this -replace @{msExchUsageLocation=$($_.msExchUsageLocation)}

Share via

PS Search filter not recognized Get-AdUser

3 answers