I have developed analytic to see what all roles are modified and created for the certain period and by whom.
But Now the requirement is to fetch any modification that was done to the role.
Could you please tell me which table holds history or modification details for the modified roles.
Solved! Go to Solution.
You can query 'roles_historychangelog' table to view similar information.
select ROLES_HISTORYCHANGELOGKEY,COMMENTS as 'Comment',CREATIONDATE,FIELDNAME,NEWVALUE,OLDVALUE,OPERATION,ROLEHISTORYKEY,ROLEKEY,UPDATEUSER from roles_historychangelog;
There is one more attribute called "modfied on". I need the date when last time role was modified in the roles_historychangelog table.
Do you know what is the column name in Saviynt DB for "modfied on" attribute?