Report of historical role assignments by user

Need a report or export that contains a history of all role assignments for given user(s)

• EERP(Munis)

• User Attributes

• Audit

• Roles

Need a history of all role assignments for a given user

To view a trail of all role assignment and deletions for a specific user, follow the steps below:

1. Navigate to EERP Menu > System Administration > Security > User Attributes

2. Search for any given user and click on View Changes in the top menu ribbon to open User Change History program

3. Export results to an Excel file and filter for value Role Assignment in column Category

To retrieve the same audit trail for all users, the following SQL query can be run against EERP database:

SELECT 

sa_key_number AS UserId,

sa_action,

sa_new_record,

sa_old_record,

sa_change_date,

sa_time_changed,

sa_changed_by

from mu_audit_history

where  

sa_file = 'roassign'

order by sa_change_date desc

To view all changes that were made to a given role, follow the steps below:

1. Navigate to EERP Menu > System Administration > Security > Roles.

2. Search for any existing role and click on View Changes in the top menu ribbon.