Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/08/2023 01:27 PM
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:
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!
05/09/2023 12:40 AM
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.
05/09/2023 06:09 AM
Thank you!!