Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Report to pull entitlements with no accounts

rajsannidhi
New Contributor III
New Contributor III

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

 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

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) 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.