Role Change History Table

[User_ID_Singh1]

Hello,

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

Thanks

[Manu269 · 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;

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

[Manu269]

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

Also please close the thread

[User_ID_Singh1]

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

[rushikeshvartak]

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;

[User_ID_Singh1]

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

[rushikeshvartak]

Roles table

[RMG]

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