Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
SecurID® Governance & Lifecycle Recipes
SecurID Governance & Lifecycle recipes is a collection of items, to help you get the most out of your product deployment. For example, a useful report with the SQL to implement or a way to achieve some advanced rule processing.
Replace "xxx" with a lower case search, like "user" or "app" or "role"
select*from user_views where lower(view_name)like'%xxx%' orderby view_name asc
SQL used in the video and presentation.
Please note that this SQL might not be relevant for your environment, so always test this in Dev before testing in Production. Some of this SQL might produce too much data and so adding a date filter (e.g.. in the last year) might be useful. The below is shared to give you examples of the SQL which was used in the demo and presentation/video.
Active Review Details (Report)
(SELECT pR.NAME, pR.END_DATE, pRS.REVIEWED_ENTS_COUNT, pRS.TOTAL_ENTS_TO_REVIEW, pRS.REVIEWED_USERS_COUNT, pRS.TOTAL_USER_COUNT, concat(CAST(((pRS.REVIEWED_ENTS_COUNT/pRS.TOTAL_ENTS_TO_REVIEW)*100)ASNUMERIC(10,0)),'%')AS Percent_Complete FROM AVUSER.PV_REVIEW pR LEFTJOIN AVUSER.PV_REVIEW_STATUS pRS ON pR.ID = pRS.REVIEW_ID WHERE pR.STATE ='InProcess')
Outstanding Review Items (Report)
(SELECT*FROM (SELECT R.NAME AS Review_Name, U.FIRST_NAME, U.LAST_NAME, U.DEPARTMENT, TOTAL_ENTS_TO_REVIEW AS Total_Review_Items, REVIEWED_ENTS_COUNT, CAST((REVIEWED_ENTS_COUNT /TOTAL_ENTS_TO_REVIEW)ASNUMERIC(10,2))AS Input_Pct, concat(CAST(((REVIEWED_ENTS_COUNT/TOTAL_ENTS_TO_REVIEW)*100)ASNUMERIC(10,0)),'%')AS Percent_Complete FROM avuser.PV_REVIEW R JOIN avuser.PV_REVIEW_REVIEWER_SUMMARY REVIEWER_STAT_BY_COMP ON R.ID = REVIEWER_STAT_BY_COMP.REVIEW_ID JOIN avuser.PV_USERS U ON REVIEWER_STAT_BY_COMP.REVIEWER_ID = U.ID WHERE R.STATE='InProcess') WHERE PERCENT_COMPLETE <>'100%' ORDERBY TOTAL_REVIEW_ITEMS DESC)
Active Reviews (Chart)
(SELECT pR.NAME, pR.END_DATE, CAST(((pRS.REVIEWED_ENTS_COUNT/pRS.TOTAL_ENTS_TO_REVIEW)*100)ASNUMERIC(10,0))AS Percent_Complete FROM AVUSER.PV_REVIEW pR LEFTJOIN AVUSER.PV_REVIEW_STATUS pRS ON pR.ID = pRS.REVIEW_ID WHERE pR.STATE ='InProcess')
Overall Review Summary (Chart)
(select state as review_state, count(*)as total_items from AVUSER.PV_REVIEW groupby state)
please comment below and hit like if this is helpful!