000032914 - How do supervisors view a report result that is specific to their subordinates in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000032914
Applies ToRSA Product Set: RSA Via Lifecycle and Governance
RSA Version/Condition: All
 
IssueSupervisors 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.
ResolutionThe 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

Attachments

    Outcomes