Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Role Change History Table

abhinavbarla
New Contributor II
New Contributor II

Hello,

Is there a way to get change history details for roles in EIC?

Thanks

7 REPLIES 7

Manu269
All-Star
All-Star

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.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

If the response answered your query, please Accept As Solution and Kudos

Also please close the thread

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

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:

abhinavbarla_0-1713350929900.png

Thanks 
Abhinav





Its working as expected trying adding alias to each column 

rushikeshvartak_0-1713402237679.png

 

 

select ROLES_HISTORYCHANGELOGKEY,COMMENTS as 'Comment',CREATIONDATE,FIELDNAME,NEWVALUE NV ,OLDVALUE OV ,OPERATION,ROLEHISTORYKEY,ROLEKEY,UPDATEUSER from roles_historychangelog;


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

Please confirm from which table we can read the creation date of the role? or is it not possible?

Roles table


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

RMG
New Contributor II
New Contributor II

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 

 
 

RMG_2-1713253187725.png