Roles and Privileges Real Time

I am required to show the date when a user was assigned a role. Is that possible either with this subject area or through a custom query. My output needs to be:

Person Number|User Suspended|Name|Role Name|Role Description|Effective Date of Role assigned to User