Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Role modification history

ArvindKumar33
New Contributor III
New Contributor III

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 

4 REPLIES 4

sahajranajee
Saviynt Employee
Saviynt Employee

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;


Regards,
Sahaj Ranajee
Sr. Product Specialist

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 

Hi Arvind,

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

Regards,

Jayasudha R

hirenp
New Contributor III
New Contributor III

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