and more in a single search tool across platforms. Read the announcement here. |
03/27/2024 10:27 PM
We have a case where we are required to build one query that should fetch entitlement value along with other entitlement details (it has a tab called Parent entitlement)
I know there is a way around to fetch child parent entitlement .However, I still want to fetch details from other entitlement details tab.
Is it possible, can anyone guide me to correct table I should use?
Thanks
Sakshi
Solved! Go to Solution.
03/27/2024 10:50 PM
Refer https://forums.saviynt.com/t5/identity-governance/analytics-report-of-entitlement-map/m-p/83502
03/28/2024 01:03 AM
Hi Rushikesh,
This will only help to fetch entitlement map values. How can I fetch parent entitlement value . I am unable to find table for it.
03/28/2024 06:58 AM
SELECT DISTINCT pep.endpointname AS 'Parent Entitlement Endpoint',
pev.entitlement_value AS 'Parent Entitlement Name',
pet.displayname AS 'Parent Entitlement Type',
cep.endpointname AS 'Child Entitlement Endpoint',
cev.entitlement_value AS 'Child Entitlement Name',
cet.displayname AS 'Child Entitlement Type'
FROM entitlements2 e2,
entitlement_values pev,
entitlement_types pet,
endpoints pep,
entitlement_values cev,
entitlement_types cet,
endpoints cep
WHERE e2.entitlement_value1key = pev.entitlement_valuekey
AND pet.entitlementtypekey = pev.entitlementtypekey
AND pet.endpointkey = pep.endpointkey
AND e2.entitlement_value2key = cev.entitlement_valuekey
AND cet.entitlementtypekey = cev.entitlementtypekey
AND cet.endpointkey = cep.endpointkey
AND pep.status = 1
03/28/2024 09:05 PM
Thanks @rushikeshvartak , entitlements2 is the table I was looking for.