Report to pull entitlements with no accounts

[rajsannidhi]

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

[rushikeshvartak]

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)