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..)
(select * from( select App_Alt_Name as "Business Source", total as "Total Items", "None", "Revoke", "Maintain", round(((("Revoke" + "Maintain") / Total) * 100),0) || '%' as "Reviewed", round((("None"/Total) * 100),0) || '%' as "Not Reviewed" From ( select App_Alt_Name, application_name, count(*) as total, sum(decode(lower(state), 'none', 1, 0)) as "None", sum(decode(state, 'Revoke', 1, 0)) as "Revoke", sum(decode(state, 'Maintain', 1, 0)) as "Maintain" from avuser.pv_review_component where review_id =:TargetObjectID group by application_name, App_Alt_Name ) where "None" >0 order by "None" 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