08/25/2022 01:58 AM
Hi Team,
We have configured below Run Time Analytics : Access Requests waiting for Approval.
SELECT DISTINCT Substr(jbpmprocessinstanceid, Instr(jbpmprocessinstanceid, '.') + 1, Length(jbpmprocessinstanceid)) requestid,
us.username AS 'Requested For',
u.username AS 'Approver Name',
aa.jbpm_activity_name AS 'Activity Name',
aa.submitdate AS 'Start Date',
CASE
WHEN ar.requesttype = 1 THEN 'Add Access'
WHEN ar.requesttype = 2 THEN 'Remove Access / Account'
WHEN ar.requesttype = 3 THEN 'NEW ACCOUNT'
WHEN ar.requesttype = 4 THEN 'ROLE REQUEST'
WHEN ar.requesttype = 11 THEN 'FFROLE REQUEST'
WHEN ar.requesttype = 12 THEN 'UPDATE ACCOUNT'
WHEN ar.requesttype = 28 THEN 'EXTEND ACCESS'
WHEN ar.requesttype = 23 THEN 'FIREFIGHTERID'
WHEN ar.requesttype = 24 THEN 'FIREFIGHTERID ACCESS'
END 'Request Type'
FROM access_approvers aa,
users u,
users us,
request_access ra,
ars_requests ar
WHERE ra.request_accesskey = aa.request_access_key
AND ra.requestkey = ar.requestkey
AND u.userkey = aa.approverkey
AND us.userkey = ra.userkey
AND ar.requesttype IN (1,2,3,4,11,12,23,24,28)
AND aa.status = 1
AND u.username= ${ukey};
We have also Configured a Dashboard of type ES Tile.
We have added the dashboard under ARS & analytics to SAV Role Also.
Now when the end user log into Saviynt and navigate to ARS > Dashboard , we are experiencing following issues :
1. The value is not getting refreshed for logged in user. I mean the data should show only display the count for which are pending for his/her approval for logged in User.
2. Upon clicking the dashboard we are getting Access Denied Error.
Please assist what needs to be corrected.
Thanks
Manish
Solved! Go to Solution.
08/25/2022 04:28 AM
You may also use USERCONTEXT in the query in order to achieve your use case this is not available in runtime analytics. Only disadvantage is you need to schedule report
08/25/2022 07:30 AM