Analytics Report of Entitlement Map

[KK]

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,

[rushikeshvartak · Accepted solution]

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 

[KK]

@rushikeshvartak 
Thanks, it works.