and more in a single search tool across platforms. Read the announcement here. |
03/24/2024 06:56 PM
Hi.
I set Entitlement Map in Endpoint.
I want to export the entitlement Map information to by analytics report.
In report, I want to output the 2 entitlement names list (Mapped combination entitlements) for specific Endpoint.
How to write SQL query for this?
Best Regards,
Solved! Go to Solution.
03/24/2024 07:10 PM
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'
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
03/24/2024 08:38 PM
@rushikeshvartak
Thanks, it works.