SODDetailData from entitlement_values table

[Shubhamjain27]

We are getting SOD violations in entitlements tab like below:

I see one column in entilement_values ie SODdetaildata which I think will give SOD details.

When I try to run that in dataanalyser, it gives information like below:

I am not able to understand the data which tables to be used to join.

Also, if someone has already worked on the report, please share.

[rushikeshvartak]

Data is stored in blob. And can’t be viewed from data analyzer / analytics. You need to run query from workbench with help of support ticket 

[Shubhamjain27]

Is it possible to check violations with the saprole under SOD workbench? I think SOD workbench is only for the violations under accounts.

[rushikeshvartak]

Does soD ruleset inside saviynt for sap then yes

[Shubhamjain27]

Can you explain how? as I tried searching for the SAProle in the SOD Violations and it is not coming: giving blank result

[rushikeshvartak]

Try reverse way from user

[Shubhamjain27]

Then it is just account SOD violation not the violations for saprole.