AzureAD aggregation user filter for the admin accounts and not equal to userprinciplename contains -da

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

i have tried many times but not accepting the query.
please suggest me one query that should get all the admin accounts instead of -da account in the admin department

2

Hi @mrahulbb ,

You can use filterString in connectorAttributes to achieve your case.

In your case, if you want to filter out all the accounts whose userprincipalName contains -da, you can use below filter string to achieve it:

[
  {
    "op": "add",
    "path": "/connectorAttributes/filterString",
    "value": "(userPrincipalName.contains(\"-da\"))"
  }
]

Below link gives a clear information on how to update the filter string via API:

Regards,
Uday Kilambi

3

In Azure ad source we have query i am looking for that query

4

it is using MG GRAPH like example ;;; deparment eq admin

5

any idea about query in mg graph in azuread