Not Able to Fetch Sav Roles History Details

[aryan9975]

Hi Team

We want to fetch the Sav Roles History Details i.e the List of Users that were added to the sav role/removed from the sav role and at what time.

The table user_savroles in Data Analyzer is not giving us the Required details.

We are aware that there are tables which are not visible in the Data analyzer and can be fetched only through analytics, for example - usergroups_history

We need a table to fetch Sav Role history in a similar way.

Thanks

Aryan

[dgandhi]

Hi @aryan9975 

I was not able to find any such table which stores history details of when users were added/removed from Sav Role.

[nimitdave]

@aryan9975 , you can have these details in Admin Function --> Audit trail as below:

object type - users

object name - username of a user 

[nimitdave]

@aryan9975 more details on sql query to fetch details: https://forums.saviynt.com/t5/identity-governance/sql-query-for-all-audit-events-in-a-time-period/m-...