07/21/2022 02:14 PM
Hi,
I'm trying to set up a analytics report to get list of entitlements with no accounts, is there a OTB report available
what is orphan field in entitlement_values table for.
I tired below query's but it doesn't pull back any results
select ev.ENTITLEMENT_VALUEKEY,ev.ENTITLEMENT_VALUE as EntitlementValue,e.ENDPOINTNAME from entitlement_values ev
join account_entitlements1 ae on ae.ENTITLEMENT_VALUEKEY=ev.ENTITLEMENT_VALUEKEY
join accounts a on ae.accountkey=a.accountkey
join endpoints e on e.endpointkey=a.endpointkey
where ae.accountkey is NULL
select
ev.ENTITLEMENT_VALUEKEY,
ev.ENTITLEMENT_VALUE as EntitlementValue,
ep.ENDPOINTNAME
from entitlement_values ev,endpoints ep,account_entitlements1 ae,accounts a
where ae.accountkey is null and ae.ENTITLEMENT_VALUEKEY=ev.ENTITLEMENT_VALUEKEY and ep.endpointkey=1
07/21/2022 04:21 PM
select
ev.ENTITLEMENT_VALUEKEY,
ev.ENTITLEMENT_VALUE as EntitlementValue,
ep.ENDPOINTNAME
from entitlement_values ev,endpoints ep, entitlement_types et
where ep.endpointkey=et.endpointkey and et.entitlementtypekey = ev.entitlementtypekey and ev.entitlement_valuekey not in ( select entitlement_valuekey from account_entitlements1)