How do supervisors view a report result that is specific to their subordinates in RSA Via Lifecycle and Governance
3 years ago
Originally Published: 2016-04-15
Article Number
000067546
Applies To
RSA Product Set: RSA Via Lifecycle and Governance
RSA Version/Condition: All
 
Issue
Supervisors might have read access to a few of the default or custom reports created in RSA Via L&G. These reports might provide details of other users too. You need  supervisors to only view results specific to their subordinates and not all the users. This can be achieved by using the dynamic variable CurrentUserID.
Resolution
The built in dynamic variable CurrentUserID can be used to restrict the user set to the subordinates. This will require creating a report definition by joining all access views (user id) to the users table and making sure that the user's supervisor matches to CurrentUserID.

Note that CurrentUserID shown in the examples below will always be replaced with the ID of logged in user when running report.

Below is a sample query that provides the list of subordinates access: 
(SELECT pUser.USER_ID, puser.FIRST_NAME, puser.LAST_NAME, pUAA.APPLICATION_NAME, pUAA.ACCOUNT_NAME, 
       pUAA.ENTITLEMENT_Type, pUAA.ENTITLEMENT_Path, pUAA.ENTITLEMENT_NAME, pUAA.VIOLATION_COUNT, 
       pUAA.IS_SHARED_ACCOUNT, pUAA.DC_NAME AS Collector_Name 
   FROM avuser.PV_USER_ALL_ACCESS pUAA LEFT JOIN 
             avuser.PV_USERS pUser 
   ON pUser.ID = pUAA.Entitled_ID
   WHERE pUser.SUPERVISOR_ID = :CurrentUserID)


Steps to create the report

  1. From the UI, create a custom report which lists subordinates access using the above query.

User-added image

  1. Now login as a supervisor who has access to run the above report. In the example below the supervisor is Jim Ducharme. The screen shot below shows the subordinates to Jim Ducharme.

 

User-added image

 

  1. Run the report created above. The report result contain details of users who are subordinates to Jim Ducharme.

 

User-added image

Don't see what you're looking for?