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

Query to fetch user role change date

Sharada
New Contributor
New Contributor

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?

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

Role is what ? application/enterprise or

role - sav role /

role is title/designation


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

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.

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...


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

Sharada
New Contributor
New Contributor

Thank you 

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

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