Role modification history

[ArvindKumar33]

Hi, 

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. 

Regards, 

Arvind 

[sahajranajee · Accepted solution]

Hello,

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;

[ArvindKumar33]

Hi Sahaj, 

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?

Regards, 

Arvind 

[jayasudha]

Hi Arvind,

"CREATIONDATE" is the column that holds the modified date in the roles_historychangelog table.

Regards,

Jayasudha R

[hirenp]

@sahajranajee Is it possible to get reference key to arstasks table for the changes logged in roles_historychangelog?