SailPoint ISC ServiceNow Account Filter

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

Hi All,

Trying to fetch user accounts from ServiceNow instance that has specific email addresses. (i.e. trying to pull accounts that has email.contains(“@source.com”) in the account filter).

Not getting any errors, aggregation runs and completes successfully but it pulls in accounts unrelated to the filter query. Has anyone successfully used the account filter to fetch accounts based on email address. Am I using the right query?

Queries I tried so far:

email CONTAINS “test.com”

!(email like “%@test.com”)

email == “john.doe@test.com”

email.endsWith(“test.com”)

These filters run but returns no accounts.

The only one where I got successful account list was the one I mentioned here →(email.contains(“@source.com”)), but it returned accounts that weren’t specified in the query.

Can someone let me know if I’m using the right filter or if I need to change the filter query.

2

Have you checked ServiceNow Filter maybe? It mentions you will have to create custom filter in SNOW, and then encode that filter before using it in SP.

1 Like
3

ServiceNow encoded query language uses LIKE to represent what you’re asking for

In the UI it might say

Email contains test.com

But the actual query string is

emailLIKEtest.com

https://www.servicenow.com/docs/bundle/zurich-platform-user-interface/page/use/using-lists/concept/c_EncodedQueryStrings.html

Also @markomanium is correct, making the query in servicenow then right clicking to copy the query is the best approach

1 Like