Get-ADUser -Filter

Question

Hi All

i have below designation in our Company. I am trying to fetch all the users who has the words Product, Manager, Mgr in their Job Title or Description. i am trying the below queries but i am not getting correct list. Experts guide me

Manager Product ABC
ABC Product Manager
Product Manager ABC
ABC Manager Product
Manager Team Product
Product Team Manager

$List ="(title -like '*Product Manager*') -or (title -like '*Product Mgr*') or (Description -like '*Product Manager*) -or (Description -like '*Product Mgr*)
Get-ADUser -Filter $List -Properties DisplayName,title,Office,description |Select DisplayName,title,Office,description | Export-csv C:\temp\output.csv -Notypeinformation

Answer 1

Try this as your filter string:

"(title -like '*product*' -and (title -like '*manager*' -or title -like *mgr*)) -or (description -like '*product*' -and (description -like '*manager*' -or description -like *mgr*))"

The reason your "-match" operator doesn't work is because it's not a supported operation. When composing filters on AD objects, think like you're composing a LDAP filter.

Answer 2

its my typo mistaking while posting i am getting output but not accurate results.
For example lets say the designation is Product Test Manager or it can be anything, if designation or title contains any words matching Product & Manager not just Product Manager i want to get that output. in my syntax i dont see it pulling Product Test Manager

$List ="(title -like 'Product Manager') -or (title -like 'Product Mgr') or (Description -like 'Product Manager') -or (Description -like 'Product Mgr')
Get-ADUser -Filter $List -Properties DisplayName,title,Office,description |Select DisplayName,title,Office,description | Export-csv C:\temp\output.csv -Notypeinformation

Answer 3

I have used the below syntax i am getting error, lets say if the users designation is Manager, Product Team then i am unable to fetch users

$List ="((description -Match '*Product|mgr|manager*') -or (title -Match '*Product|mgr|manager*'))"
Get-ADUser -Filter $List -Properties DisplayName,title,Office,description |Select DisplayName,title,Office,description | Export-csv C:\temp\output.csv -Notypeinformation

Get-ADUser : Error parsing query: ((description -Match 'Product|mgr|manager') -or (title -Match 'Product|mgr|manager'))' Error Message: 'Operator Not supported: -Match'
at position: '98'.
At line:2 char:1

• Get-ADUser -Filter $Q -Properties DisplayName...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : ParserError: (:) [Get-ADUser], ADFilterParsingException
• FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADFilterParsingException,Microsoft.ActiveDirectory.Management.Commands.GetADUser