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.
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
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