We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Which table stores Other entitlement details / Entitlement map

ant
New Contributor
New Contributor


Hello,


we have a requirement to list an endpoint entitlements and its subentitlements/entitlement map

Any idea which table stores this Other entitlement details / Entitlement map? or how to approach this?

 

Ant_0-1673959789282.png

 

Thank you!

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

entitlementmap


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

Do you have an example of analytics how to archive this?

select 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',IFNULL(CASE WHEN map.requestfilter = 1 THEN 'True' ELSE 'False'  END,  'False') AS 'request filter', IFNULL(CASE WHEN map.adddependenttask = 1 THEN 'True' ELSE 'False'  END,  'False') AS 'Add Dependent Task', IFNULL(CASE WHEN map.removedependententtask = 1 THEN 'True' ELSE 'False'  END,  'False') AS 'Remove Ent Task', IFNULL(CASE WHEN map.excludeentitlement = 1 THEN 'True' ELSE 'False'  END,  'False') AS 'Exclude Ent' 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.ENDPOINTNAME) in ('Endpoint Name1','Endpoint Name 2')


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

Sivagami
Valued Contributor
Valued Contributor

Try the below query. It list all the entitlement maps defined for all endpoints. If you need for specific endpoint entitlement put the where condition at the end of the query - where ep1.endpointname='<myendpointname>'

 

SELECT e.entitlement_value1key  AS 'PARENTENTVALKEY',
       ev1.entitlement_value    AS 'PARENTENTNAME',
       ev1.displayname          AS 'PARENTENTDISPLAYNAME',
       et1.entitlementtypekey   AS 'PARENTENT_ENTTYPEKEY',
       et1.entitlementname      AS 'PARENTENT_ENTTYPE',
       ep1.endpointkey          AS 'PARENTENT_EPKEY',
       ep1.endpointname         AS 'PARENTENT_EP',
       ep1.displayname          AS 'PARENTENT_EPDISPLAYNAME',
       e.entitlement_value2key  AS 'MAPPEDENTVALKEY',
       ev2.entitlement_value    AS 'MAPPEDENT',
       ev2.displayname          AS 'MAPPEDENTDISPLAYNAME',
       et2.entitlementtypekey   AS 'MAPPEDENT_ENTTYPEKEY',
       et2.entitlementname      AS 'MAPPEDENT_ENTTYPE',
       ep2.endpointkey          AS 'MAPPEDENT_EPKEY',
       ep2.endpointname         AS 'MAPPEDENT_EP',
       ep2.displayname          AS 'MAPPEDENT_EPDISPLAYNAME',
       e.adddependenttask       AS 'ADDDEPENDENTENTTASK',
       e.removedependententtask AS 'REMOVEDEPENDENTENTTASK'
FROM   entitlementmap e
       JOIN entitlement_values ev1
         ON e.entitlement_value1key = ev1.entitlement_valuekey
       JOIN entitlement_values ev2
         ON e.entitlement_value2key = ev2.entitlement_valuekey
       JOIN entitlement_types et1
         ON et1.entitlementtypekey = ev1.entitlementtypekey
       JOIN entitlement_types et2
         ON et2.entitlementtypekey = ev2.entitlementtypekey
       JOIN endpoints ep1
         ON ep1.endpointkey = et1.endpointkey
       JOIN endpoints ep2
         ON ep2.endpointkey = et2.endpointkey

 

-Siva