Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Azure AD Connector - multiple accounts_filter criteria on importing accounts

Ian
New Contributor II
New Contributor II

Hi all. We are trying to apply multiple filter criteria to the ACCOUNTS_FILTER configuration on our Azure AD Connector, but can't work out the required syntax.

This statement:

startswith(extension_ourGUID#_employeeType,'Staff')&onPremisesSyncEnabled eq true

only applies the first filter (looking for startswith Staff), and doesn't filter by onPremisesSyncEnabled . I.e. we only want to import accounts that are both marked as 'Staff' and synched from on-premise.

Has anyone else managed to filter on multiple attributes in the ACCOUNTS_FILTER?

What's the syntax you used for writing those multiple filter criteria? It's not clear if it's powershell syntax or something else.

Many thanks for any help or suggestion.

Ian

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Is it working on postman ?

https://learn.microsoft.com/en-us/answers/questions/513163/filterquery-azure-ad-dynamic-versus-assig... 

https://learn.microsoft.com/en-us/answers/questions/898753/negation-in-filter-on-azure-resource-grap... 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Ian
New Contributor II
New Contributor II

Thanks for your attention.

It was a syntax issue we tracked down, using the MS Graph Explorer. This worked:

startswith(extension_ourGUID#_employeeType,'Staff') AND onPremisesSyncEnabled eq true