Hi,
We need a way in which we can get the name of the user's previous manager.
We have a requirement in Saviynt where we want to notify the user and manager if the manager of the user is changed.
We want to notify the old manager and the new manager with email.
We created a user-update rule and have added the email template in action. But could not figure out a way to notify the previous manager.
Once the user's manager is updated, the user attribute 'manager' and 'owner' naturally considers the current manager. But how can we find out the previous manager and email them.
We thought of using user-update rule and populating the value of current manager in some customeproperty. and when manager is changed, this customproperty value will have the old manager's details..
But this method of implementation will consume space of 2 customproperties and will add load to the scheduled jobs
We also thought if we can use the user history details in some way. We got USERSHISTORY table but that is not giving fruitful information.
Haardik Verma
Isn't there any way to convert this to string ?
I tried this query :
select CONVERT(changelog using utf8), userkey from usershistory
It does not show any error in Data Analyzer and runs properly, but in the output, the changelog column is blank
