Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Azure Account Correlation Rule for Data inconsistency

Sunny
New Contributor III
New Contributor III

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?

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Sunny
New Contributor III
New Contributor III

Hi @rushikeshvartak 

 

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?

 

You can use multi threaded job


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.