UserAccount Correlation RUle

[sk]

Hello experts,

We have an issue where we are importing accounts from target we are importing only the UPN(UserPrincipalName).

But in users no attribute is storing the UPN value. 

UPN eg: abc.xyz@onmicrosoft.com

User Email eg:abc.xyz@gmail.com

The only common here usersfirstname.lastname

Please let me know how can we corelate 

[NM]

Hi @sk , reconstruct the upn using user field in advance config of user account correlation rule

You can use substring function.

[PremMahadikar]

Hi @sk ,

Use the below code in account correlation rule:

concat(users.firstname,'.',users.lastname)=SUBSTRING_INDEX(accounts.name,'@',1) # SUBSTRING_INDEX(users.email,'@',1)=SUBSTRING_INDEX(accounts.name,'@',1)

If this helps your question, please consider selecting Accept As Solution and hit Kudos

[rushikeshvartak]

CONCAT( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.firstname, '-', ''), '/', ''), ',', ''), '''', ''), '.', ''), '(', ''), ')', ''), ' ', ''), '.', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(users.lastname, '-', ''), '/', ''), ',', ''), '''', ''), '.', ''), '(', ''), ')', ''), ' ', '') ) = SUBSTRING_INDEX(accounts.name, '@', 1)

replaced all special characters from first name and last name