Get-ADUser Filter query

Question

Get-ADUser Filter query

Roger Roger 7,181

Hi All,

In Active Directory, I have the office and country attributes in the following format:

Office=Remote, FL, USA Country=United States of America 
Office=FL, USA Country=United States of America

I want to pull all users who have 'Remote' in their office location and 'United States of America' as their country. For example, if any user has an office location like 'Remote, UT,' they should also be included. Is the following query correct? (It should pull combination of 'Remote' and 'United States of America'):

(Office -like 'Remote*') -and (co -like '*United States of America*')

I also want to pull all users who have 'FL' in their office location and 'United States of America' as their country. However, when I use the following query, it also pulls users with 'Remote' in their office location, i dont want remote users.i am just looking for FL user not Remote, FL users please guide me.

(Office -like 'FL*') -and (co -like '*United States of America*')

Accepted answer

1 additional answer

Your answer

Answer 1

Do you want both conditions in the same pass, or in two separate passes?

This should work if you stick with using the "Country" property.

# Remote users in US
get-aduser  -Filter * -properties Office,Country|
    Where-Object {$_.Office -like "Remote,*" -And $_.country -eq "US"} |
        Select-Object Name, Office, Country

# Users in the state of Florida, US
get-aduser  -Filter * -properties Office,Country|
    Where-Object {$_.Office -match "^FL," -And $_.country -eq "US"} |
        Select-Object Name, Office, Country

The "co" property is just "United States", isn't it?

Answer 2

Roger Roger 7,181

Remote users in US is working perfectly fine.

Users in the state of Florida, US is not working i tried the below combinations

$query ="(Office -match '^FL,' -and country -eq 'United States of America')" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

$query ="(Office -like '^FL,' -and country -like 'United States of America')" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

$query ="((Office -like 'FL,') -and (country -like 'United States of America'))" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

$query ="((Office -like '^FL,') -and (country -like 'United States of America'))"
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

Rich Matheisen 47,901

You're correct, those won't work. But that's because a filter has different limitations to a PowerShell statement.

# won't work. the "-match" operator cannot be used in a filter
$query ="(Office -match '^FL,' -and country -eq 'United States of America')" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

# won't work. the string "^FL," is a "regular expression". When used with "-like" the '^' is
# just a character. In a regex it means "beginning of line".
$query ="(Office -like '^FL,' -and country -like 'United States of America')" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

# won't work. the "-like" operator needs a wildcard in the string.
$query ="((Office -like 'FL,') -and (country -like 'United States of America'))" 
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

These will work:

$query = "(Office -like 'FL,*' -AND country -eq 'US')"
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

$query = "(Office -like 'Remote,*' -AND country -eq 'US')"
Get-ADUser -Filter $query -Properties Name,Office,Country|Select Name,Office,Country

Share via

Get-ADUser Filter query

1 additional answer

Your answer