RSA IGL Version: V 7.2.x
This chart provides key information about the application which have the most outstanding items left to be completed. It is a dynamic chart.
The goal of this chart is to understand which applications might need some help/focus, to get the review completed.
The chart can be used by Review owners or the admin team to better understand which application owners to contact and support during the review process.
This chart will only work when it is applied dynamically to the Review Results object dashboard.
The following value needs to be used when creating the chart, 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 app_alt_name, round(100 * COUNT(decode(IS_REVIEWED , 'False', NULL, 1))/COUNT(1), 2) Percent_Reviewed, round(100 * COUNT(decode(IS_REVIEWED , 'True', NULL, 1))/COUNT(1), 2) Percent_Not_Reviewed from avuser.pv_review_component where review_id =:TargetObjectID group by app_alt_name order by 3 desc fetch first 10 rows only )
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
There are MANY other "display attributes" you can play with on this screen, so please update and make changes as you see fit.