Entitlements with no owners

[MM]

Can anyone point me to a query to find all the entitlements with no owners listed?

I tried checking userkey  in "entitlement_owners" table but couldn't find the anyone without userkey.

Something like this and of course it didn't work

select
ev.DISPLAYNAME as DisplayName,
ev.ENTITLEMENT_VALUE as Description,
u.username as username,
e.endpointname as Application,
eo.UPDATEDATE as Update_Date
from entitlement_values ev,
entitlement_owners eo,
users u,
entitlement_types et,
endpoints e
where
ev. ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY and
eo.USERKEY is null and
ev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY and
e.ENDPOINTKEY=et.ENDPOINTKEY and ev.status=1

[NM]

@MM , join 2 tables entitlement value and owners and have a where condition where eo.userkey is null

[MM]

Thanks - you mean below? I still don't see any data

select
ev.DISPLAYNAME as DisplayName,
ev.ENTITLEMENT_VALUE as Description,
u.username as username,
e.endpointname as Application,
eo.UPDATEDATE as Update_Date
from entitlement_values ev,
entitlement_owners eo,
users u,
entitlement_types et,
endpoints e
where
ev. ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY and
eo.USERKEY=u.USERKEY and
ev.ENTITLEMENTTYPEKEY=et.ENTITLEMENTTYPEKEY and
e.ENDPOINTKEY=et.ENDPOINTKEY and ev.status=1 and eo.USERKEY is null

[NM]

@MM 

select

ev.DISPLAYNAME as DisplayName,

ev.ENTITLEMENT_VALUE as Description,

eo.UPDATEDATE as Update_Date

from entitlement_values ev,

entitlement_owners eo

Where ev. ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY and eo.userkey is null

[MM]

This no data....and that what I was trying to mention that I don't see any data with userkey in entitlement_owners is NULL. I can assure we do have entitlements with no owners. So if entitlement_owners is not the right table to look at, do we need to look at another table?

[NM]

@MM can you share column of entitlement owners table.

[Manu269]

Please join following tables :

entitlement_values

entitlement_types

entitlement_owners

users

and endpoints

[rushikeshvartak]

SELECT EV.DISPLAYNAME       AS DisplayName,
       EV.ENTITLEMENT_VALUE AS Description,
       U.USERNAME           AS Username,
       E.ENDPOINTNAME       AS Application,
       EO.UPDATEDATE        AS Update_Date
FROM   ENTITLEMENT_VALUES EV
       LEFT JOIN ENTITLEMENT_OWNERS EO
              ON EV.ENTITLEMENT_VALUEKEY = EO.ENTITLEMENT_VALUEKEY
       LEFT JOIN USERS U
              ON EO.USERKEY = U.USERKEY
       JOIN ENTITLEMENT_TYPES ET
         ON EV.ENTITLEMENTTYPEKEY = ET.ENTITLEMENTTYPEKEY
       JOIN ENDPOINTS E
         ON ET.ENDPOINTKEY = E.ENDPOINTKEY
WHERE  EO.USERKEY IS NULL
       AND EV.STATUS = 1;