User secondryEmail and displayname is not working in Correlation Rule

[hemanthvn]

Hello All,

Users SecondaryEmail  and displayname  in the Correlation Rule is not working. But for users email attribute Correlation is working expected.

We have tried in both basic and Advance config But it didn't work. We have tried  SecondaryEmail  and displayname individually But it didn't work.

Please Let me know if anybody having idea or solution for this issue.

Regards

Hemanth

[nimitdave]

Are you getting any errors in the logs.

[Manu269]

I dont see any config error.

[nimitdave]

In the logs are you seeing the equivalent of below as per your rule:

2023-06-02 08:56:37,802 [quartzScheduler_Worker-9] DEBUG saviynt.ImportExternalDbService - Rule: users.username=accounts.name
2023-06-02 08:56:37,805 [quartzScheduler_Worker-9] DEBUG saviynt.ImportExternalDbService - sql =
SELECT USERS.USERKEY AS USERKEY, ACCOUNTS.ACCOUNTKEY AS ACCOUNTKEY FROM ACCOUNTS ACCOUNTS
LEFT JOIN USER_ACCOUNTS UA ON ACCOUNTS.ACCOUNTKEY = UA.ACCOUNTKEY
LEFT JOIN USERS USERS ON
users.username=accounts.name
WHERE ACCOUNTS.ENDPOINTKEY = 10 AND ACCOUNTS.STATUS IN ('Active','1','Manually Provisioned')
AND ACCOUNTS.ACCOUNTKEY IS NOT NULL AND UA.ACCOUNTKEY IS NULL
AND ACCOUNTS.NAME IS NOT NULL AND USERS.USERNAME IS NOT NULL

[hemanthvn]

Hello,

I didn't see any proper error in the Logs. And there are 46000+ account are there in orphan state

And Yes, I can able to see above kind of Sql query in Logs as per our rule.

Thanks

Hemanth

[dgandhi]

Have you tried with advance config?

[hemanthvn]

Hello,

I have tried in advance config also,  It is not working.

Thanks

Hemanth