Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/02/2024 10:03 PM - edited 05/02/2024 10:15 PM
In Azure we have inconsistent data(Not all data are coming for each user) for that we are using Advanced Correlation rule in endpoint configuration.
Where:
"customproperty13": "onPremisesSamAccountName",
"customproperty4": "mail",
"customproperty9": "mailNickname",
I have tried to make the below two advances query however its not working properly
Approach 1:
WHEN (users.EMAIL = accounts.CUSTOMPROPERTY4) THEN accounts.CUSTOMPROPERTY4
WHEN (users.username = accounts.customproperty9) THEN accounts.CUSTOMPROPERTY9
WHEN (concat(users.username,'@abc.com') = accounts.customproperty4) then accounts.CUSTOMPROPERTY4
WHEN concat(users.username,'@xyz.com') = accounts.customproperty4 THEN accounts.CUSTOMPROPERTY4
ELSE accounts.CUSTOMPROPERTY13 END
Approach 2:
WHEN users.EMAIL = accounts.CUSTOMPROPERTY4 THEN accounts.CUSTOMPROPERTY4
WHEN users.username = accounts.customproperty9 THEN accounts.CUSTOMPROPERTY9
WHEN users.username=accounts.CUSTOMPROPERTY13 THEN users.username
WHEN CONCAT(users.username, '@abc.com') = accounts.customproperty4 OR CONCAT(users.username, '@xyz.com') = accounts.customproperty4 THEN accounts.CUSTOMPROPERTY4
ELSE users.username
END
Approach 3 :
This approach is working for few sets of users however when we are running Full import job then the job is getting stuck and status eventually shows failed.
users.email = accounts.customproperty4 OR concat(users.username,'@abc.com') = accounts.customproperty4 OR concat(users.username,'@xyz.com') = accounts.customproperty4 OR users.username = accounts.customproperty9 OR users.username = accounts.customproperty13
How should we approach?
05/02/2024 10:21 PM
CASE
WHEN users.EMAIL = accounts.CUSTOMPROPERTY4 THEN accounts.CUSTOMPROPERTY4
WHEN users.username = accounts.customproperty9 THEN accounts.CUSTOMPROPERTY9
WHEN users.username = accounts.CUSTOMPROPERTY13 THEN users.username
WHEN CONCAT(users.username, '@abc.com') = accounts.customproperty4 THEN accounts.CUSTOMPROPERTY4
WHEN CONCAT(users.username, '@xyz.com') = accounts.customproperty4 THEN accounts.CUSTOMPROPERTY4
ELSE accounts.CUSTOMPROPERTY13
END
05/03/2024 12:51 AM
For Single user or a small set of user the Query works fine but when trying to do Full Import its taking longer time. Any suggestions to optimize it?
05/05/2024 07:23 PM
You can use multi threaded job