This report provides details on all the reviewers, who still have outstanding items left to be completed.
The goal of this report is to provide clear information on outstanding review activity, with easy to understand metrics.
The report can be used by Review owners or the admin team to better understand the reviewers overall and which ones to potentially focus on.
This report will only work when it is applied dynamically to the Review Results object dashboard.
The following value needs to be used when creating the report, however the value will update dyncamilly when used within the dashboard.
How to find an Example Target Object ID:
First test this in your query tool (SQLDeveloper, Toad etc..)
pU.First_name || ' ' || pU.Last_name as Reviewer_Name,
pu.email_address as Email,
pu.Supervisor_id_name as Supervisor_Name,
t1.Total_to_Review as Total,
t1.Completed_Items as Completed,
t1.Outstanding_Items as Outstanding,
round(((t1.Outstanding_Items / t1.Total_to_Review) * 100),0) || ' %' as Percent
COUNT(1) as Total_to_Review,
COUNT(1) - COUNT(decode(IS_REVIEWED , 'False', NULL, 1)) AS Outstanding_Items,
COUNT(1) - COUNT(decode(IS_REVIEWED , 'True', NULL, 1)) AS Completed_Items
from avuser.pv_review_component Tcomp
join avuser.pv_review_coverage Tcov
on Tcomp.id = Tcov.REVIEW_COMPONENT_ID
where Tcov.role_type = 'Reviewer'
group by REVIEW_ID, COVERING_USER_ID
Left join avuser.pv_users pU
on pU.id = t1.COVERING_USER_ID
Where Outstanding_Items > 0
order by Outstanding_Items desc
Example of the results:
If you get an error at this stage, please test your SQL in a Query tool, like "SQL Developer" or "SQL Squirrel" to ensure it works first.
If it still doesn't work, please share your SQL and a screen shot of the issue below. DO NOT contact RSA Support