Query - Active Entitlements found with Inactive Owners

 SELECT u.username       AS 'Entitlement_owner',

       u.displayname,
       u.employeeclass,
       u.departmentname AS 'DEPARTMENT',
       CASE u.statuskey
         WHEN 1 THEN 'Active'
         WHEN 0 THEN 'Inactive'
       END              AS 'USERSTATUS',
       ev.entitlement_value,
       et.entitlementname,
       ep.endpointname,
       ep.endpointkey   AS endpointKey
FROM   users u
       INNER JOIN entitlement_owners eo
               ON u.userkey = eo.userkey
       INNER JOIN entitlement_values ev
               ON eo.entitlement_valuekey = ev.entitlement_valuekey
       INNER JOIN entitlement_types et
               ON ev.entitlementtypekey = et.entitlementtypekey
       INNER JOIN endpoints ep
               ON et.endpointkey = ep.endpointkey
WHERE  u.statuskey = 0;