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?
