Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Query to fetch the remove access

sk
Regular Contributor
Regular Contributor

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

 

2 REPLIES 2

Raghu
Honored Contributor
Honored Contributor

@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...

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

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
    

rushikeshvartak_1-1716358525428.png

rushikeshvartak_2-1716358560321.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.