and more in a single search tool across platforms. Read the announcement here. |
01/17/2023 04:51 AM
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?
Thank you!
Solved! Go to Solution.
01/17/2023 05:19 AM
entitlementmap
01/17/2023 06:22 AM
Do you have an example of analytics how to archive this?
01/17/2023 11:58 AM
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')
01/17/2023 11:47 AM - edited 01/17/2023 11:49 AM
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