How do supervisors view a report result that is specific to their subordinates in RSA Via Lifecycle and Governance
Originally Published: 2016-04-15
Article Number
Applies To
RSA Version/Condition: All
Issue
Resolution
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
- From the UI, create a custom report which lists subordinates access using the above query.
- 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.
- Run the report created above. The report result contain details of users who are subordinates to Jim Ducharme.
