We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Movers - Old information for a notification

PiouPiou
New Contributor
New Contributor

Hello,

I'd like to send an email when a mover is detected. And in my email template, I'd like to put in the old and the new information of the user. For example, if a mover is detected and the manager of the user has changed, in my email template, I'd like to have something that would contain: 

  • " User's old manager: John Doe
  • User's new manager: Indiana Jones"

In sum,  it is the "John Doe" in my example that I'm unable to get as the user's manager is Indiana Jones when the email is sent.

So would you know if there is a way to get the informations that were there before an update and put them in the email template with the new informations?       

Thank you in advance!                                          

2 REPLIES 2

nimitdave
Saviynt Employee
Saviynt Employee

You can try creating an analytics control as below, changelog column has details of the updates:

select u.username, u.userkey, uh.changelog from users u inner join usershistory uh on u.userkey=uh.userkey where username=${username}

And then you can deserialize the contents.

PiouPiou
New Contributor
New Contributor

Thank you!!