Query to fetch the remove access

[sk]

Hello Experts,

Can someone help me to fetch the query for remove access for both child and parent endpoint.

We have added the config

Entilement value-->other entitlement details-->added parent entitlement -->enabled dependent task-->enabled Remove Ent Task

[Raghu]

@sk  please use below

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 

https://forums.saviynt.com/t5/identity-governance/query-to-fetch-other-entitlement-details/m-p/84341

https://forums.saviynt.com/t5/general-discussions/how-to-get-query-for-child-and-parents-entitlement...

[rushikeshvartak]

SELECT DISTINCT pep.endpointname      AS 'Parent Entitlement Endpoint',
                pev.entitlement_value AS 'Parent Entitlement Name',
                cep.endpointname      AS 'Child Entitlement Endpoint',
                cev.entitlement_value AS 'Child Entitlement Name',
                map.requestfilter,
                map.removedependententtask,
                map.excludeentitlement,
                map.adddependenttask
FROM   entitlementmap map,
       entitlement_values pev,
       entitlement_types pet,
       endpoints pep,
       entitlement_values cev,
       entitlement_types cet,
       endpoints cep
WHERE  map.entitlement_value1key = pev.entitlement_valuekey
       AND pet.entitlementtypekey = pev.entitlementtypekey
       AND pet.endpointkey = pep.endpointkey
       AND map.entitlement_value2key = cev.entitlement_valuekey
       AND cet.entitlementtypekey = cev.entitlementtypekey
       AND cet.endpointkey = cep.endpointkey
       AND pep.status = 1
       AND pep.endpointname != cep.endpointname