Correlation rule is not working

[gwagh]

Hi Team, 

I have configured correlation rule in SQL format but while importing accounts its correlating only active account with user for inactive account its creating orphan account. There is any configuration for this ? or thing I missed ? 

Ex- concat(users.email,'.xyz')=(accounts.name)

Thanks,

Gaurav  

[This message has been edited by moderator to merge reply comment]

[armaanzahir · Accepted solution]

Hi @gwagh 

Which connector are you using?

Have you configured the STATUS_THRESHOLD_CONFIG for the connector?

Below is a sample for the AD connector:

{
"statusAndThresholdConfig": {
"statusColumn": "customproperty17",
"activeStatus": [
"512",
"544",
"66048"
],
"inactiveStatus": [
"546",
"514",
"66050"
],
"deleteLinks": false,
"accountThresholdValue": 1000,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false

}

This above highlighted configuration needs to be added to the configuration in order for the import to correlate inactive accounts to users. This should help alleviate your issue

Configuring the Integration for Importing Accounts and Access (saviyntcloud.com)

[gwagh]

Thanks Its working fine I missed this configuration.