Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/16/2024 12:22 AM
04/16/2024 12:33 AM
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;
Note : "CREATIONDATE" is the column that holds the modified date in the roles_historychangelog table.
04/17/2024 12:04 AM
If the response answered your query, please Accept As Solution and Kudos
Also please close the thread
04/17/2024 03:49 AM
Hi Manu
I tried the query which you have provided above:
select ROLES_HISTORYCHANGELOGKEY,COMMENTS as 'Comment',CREATIONDATE,FIELDNAME,NEWVALUE,OLDVALUE,OPERATION,ROLEHISTORYKEY,ROLEKEY,UPDATEUSER from roles_historychangelog;
If i use NEWVALUE and OLDVALUE columns it showing below error:
Thanks
Abhinav
04/17/2024 06:04 PM
Its working as expected trying adding alias to each column
select ROLES_HISTORYCHANGELOGKEY,COMMENTS as 'Comment',CREATIONDATE,FIELDNAME,NEWVALUE NV ,OLDVALUE OV ,OPERATION,ROLEHISTORYKEY,ROLEKEY,UPDATEUSER from roles_historychangelog;
05/21/2024 04:56 AM
Please confirm from which table we can read the creation date of the role? or is it not possible?
05/21/2024 05:45 AM
Roles table
04/16/2024 12:40 AM
Please refer to following document for Role table details : https://docs.saviyntcloud.com/bundle/SSM-DB-Schema-Reference-v55x/page/Content/Identity-Repository-S...
Also you can get History from UI