10/04/2022 01:06 PM
How to Identify if the access request has SOD conflict? I found a column -SODevaluated in table ars_requests but the value of this column is sometimes greater than 0. When I open and check such requests with sodevaluated > 0, I don't actually see an SOD conflict.
How to truly identify the requests with SOD? Any help is much appreciated.
-Siva
10/04/2022 02:07 PM
If request having entry in request_exceptions table
SELECT SUBSTRING_INDEX(ar.jbpmprocessinstanceid, '.', - 1) AS 'Request_ID', ar.requestdate, monthname(ar.requestdate) as CreatedMonth FROM request_exceptions re, ars_requests ar WHERE re.REQUESTKEY = ar.REQUESTKEY;
SODevaluated in table ars_requests introduced for external sod
10/06/2022 07:16 AM
Thanks @rushikeshvartak for the insights!
Have couple of follow up questions:
1) What's the difference between internal & external SOD?
2) How to identify the number of requests system evaluated SOD and out of which number of requests SOD was detected?
-Siva
10/06/2022 11:35 AM
1) What's the difference between internal & external SOD?
Internal SOD is something ruleset is inside Saviynt & saviynt is calculating SOD Evolution.
External SOD is calculated outside Saviynt like GRC tool
2) How to identify the number of requests system evaluated SOD and out of which number of requests SOD was detected?
SELECT SUBSTRING_INDEX(ar.jbpmprocessinstanceid, '.', - 1) AS 'Request_ID', ar.requestdate, monthname(ar.requestdate) as CreatedMonth,count(ar.requestkey)countofsod FROM request_exceptions re, ars_requests ar WHERE re.REQUESTKEY = ar.REQUESTKEY group by ar.requestkey