Analytics to get all role adds and removals

[yogesh]

I am trying to make an analytics report that can list down all the roles add and removes for a user, and have below observations:

1. Roles added / removed via requests are captured in the ars_requests table.
   Roles
2. Role added removed via role_management screen (see screenshot below), are also recorded in ars_requests table:
   
3. ISSUE: I can not find the record of roles removed via user update rule, we have a rule to remove all enterprise roles when user is disabled but no request is generated for this kind of role removal.
   So where can I find these removals?
   I can see it is being recorded here but not able to find the table name to use in analytics:
   

[sai_sp · Accepted solution]

You can get the information you need from the roles_historychangelog table. The following columns could be used from the table for your requirement.

FIELDNAME, NEWVALUE, OLDVALUE, ROLEKEY, OPERATION