User account correlation rule implementation

[Ekata]

Hi Team,

We have a requirement to correlate a privilege account to the user actual profile. The issue is the username is not same as account name.

Ex: If Username is 56607, so the user profile will have AD account with 56607 as account name and the privilege account is having account name as ADM56607. Due to this difference the account is not getting synced with the user profile.

Tried creating the user account correlation rule as :

But this rule does not help. Can you please confirm how we can resolve it. Do we need to create separate Endpoint?

Kindly check and advise.

Version is v2020.1.2

Regards,

Ekata Bharati

[rushikeshvartak]

use advance config as below

(users.username)=RIGHT(accounts.name,5)

[Ekata]

Hi Rushikesh,

Thanks for the response. 

There are 2 more rules present in it. So how can I separate them in advance query?

Above is the other 2 rules used in user account correlation section.

Regards,

Ekata 

[rushikeshvartak]

(users.username)=RIGHT(accounts.name,5) or (users.customproperty28)=(accounts.name)

[Belwyn]

Hi @Ekata 

Could you please try something like 

(users.username)=concat(accounts.name, 4, 8   )

Regards, 

Belwyn.

[iqbalsingh · Accepted solution]

you can try below advance config

concat("ADM",users.username)=(accounts.name) # (users.username)=(accounts.name) # (users.customproperty28)=(accounts.name)

[Ekata]

Hi Iqbal,

Thanks for the solution provided. can you please also help me to concat the account name as ADM.firstname.lastname. for example if the account name is 

ADM.michael.adams

 how we can use it?

[rushikeshvartak · Accepted solution]

concat("ADM",users.username)=(accounts.name) # (users.username)=(accounts.name) # (users.customproperty28)=(accounts.name)# concat(users.firstname,'.',users.lastname)=(accounts.name)

[Ekata]

Thank you. 

[Ekata]

Hi All,

Thanks for the response. It worked.

Regards,

Ekata