Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

How to truncate email for account correlation rule

ZA
New Contributor III
New Contributor III

Hello,

Could not find any examples in the documentation to show how to use SQL for account correlation.

The target system has accounts in this format: email+build@domain.com.

What I need to do is remove the +build from the account name so it's just email address left, then match it with user.email. How can I achieve this?

2 REPLIES 2

Ishan
Saviynt Employee
Saviynt Employee

You can try this:

CONCAT(LEFT(accounts.name, LOCATE('+', accounts.name)-1),  
                   SUBSTRING(accounts.name, LOCATE('@', accounts.name))) = users.email

Test it in data analyzer first for one of the users and if its displaying the result as expected, you can use it in Advanced Config in User Account Correlation rule at the Endpoint level. 

Ishan Kamat
Technical Architect, Professional Services
SaviyntLogo.png

ZA
New Contributor III
New Contributor III

Thank you Ishan, that worked perfect.