Query to fetch user role change date

[Sharada]

Hi all, 

My requirement is get the date of user's role change. We need a report which contains the list of users whose role was updated in a particular period. What query can be written to get above data?

[rushikeshvartak]

Role is what ? application/enterprise or

role - sav role /

role is title/designation

[Sharada]

Hi,

Role here is job function. My ask here is to get the list of all users whose job function was changed along with the date.

[rushikeshvartak]

Its stored in blob data in userhistory table which is supported in v22.x onwards.

since you are on v5.5 its not supported for you

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An...

[Sharada]

Thank you 

[rushikeshvartak · Accepted solution]

If you find the response useful, kindly consider selecting Accept As Solution and by clicking on the kudos button.