Query to fetch Other entitlement details

[Sakshi2806]

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 

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/analytics-report-of-entitlement-map/m-p/83502

[Sakshi2806]

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.

[rushikeshvartak · Accepted solution]

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 

[Sakshi2806]

Thanks @rushikeshvartak , entitlements2 is the table I was looking for.