Account Filter for Azure AD accounts

[Prajna]

Hi Team,

There is a requirement to filter the Azure AD accounts from importing into Saviynt.Can you please suggest us the accounts filter criteria that needs to be used. The below mentioned accounts are samples. Need to filter all the accounts that starts with A*****, T*****A, T*****DA, T*****XA

A12345@xyz.com

T12345A@xyz.com

T12345DA@xyz.com

T12345XA@xyz.com

[rushikeshvartak · Accepted solution]

1. Accounts that start with "A*****":

   • Filter: startsWith(userPrincipalName, "A")

2. Accounts that start with "T*****A":

   • Filter: startsWith(userPrincipalName, "T") && endsWith(userPrincipalName, "A")

3. Accounts that start with "T*****DA":

   • Filter: startsWith(userPrincipalName, "T") && endsWith(userPrincipalName, "DA")

4. Accounts that start with "T*****XA":

   • Filter: startsWith(userPrincipalName, "T") && endsWith(userPrincipalName, "XA")

[rushikeshvartak]

((userPrincipalName eq 'A*') or (userPrincipalName eq 'T*') or (userPrincipalName eq 'T*DA') or (userPrincipalName eq 'T*XA'))

[Prajna]

Hi Rushikesh,

We have tried using the below mentioned filter for filtering the accounts that starts with A. Tried to run the account import job for Azure AD. It fails witha warning that the "status threshold has been breached. The json for status threshold is mentioned below. Kindly let us know if any modification required in the threshold setting.

(userPrincipalName eq 'A*') 

Status Threshold:

{
"statusAndThresholdConfig": {
"accountThresholdValue": 1000,
"appAccountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"statusColumn": "customproperty10",
"activeStatus": [
"true"
],
"deleteLinks": true
}
}

[rushikeshvartak]

• How many total active exists accounts exists in saviynt
• how many accounts matching above filter criteria 

[Prajna]

There are 147 active accounts. 94 accounts match the filter criteria.

[rushikeshvartak]

Then threshold error should not come as total  147< 1000