Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Extracting all Entitlements with terminated users as owners

Saviyntreh
New Contributor II
New Contributor II

Hi,

Extracting all Entitlements with terminated users as owners

 

regards,

 

3 REPLIES 3

PremMahadikar
Valued Contributor
Valued Contributor

Hi @Saviyntreh ,

This is your query:

select ev.ENTITLEMENT_VALUE, u.username, case when u.statuskey=0 then 'Inactive' when u.statuskey=1 then 'Active' else u.statuskey end as 'Userstatus' from entitlement_values ev, entitlement_owners eo,users u where ev.ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY and eo.userkey=u.userkey and u.statuskey=0

 

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

Saviyntreh
New Contributor II
New Contributor II

please include endpoint details

@Saviyntreh ,

select ev.ENTITLEMENT_VALUE,et.displayname as 'Entitlement Type',ep.displayname as 'Application Name', u.username, case when u.statuskey=0 then 'Inactive' when u.statuskey=1 then 'Active' else u.statuskey end as 'Userstatus' from entitlement_values ev, entitlement_owners eo,users u,entitlement_types et ,endpoints ep where ev.ENTITLEMENT_VALUEKEY=eo.ENTITLEMENT_VALUEKEY and eo.userkey=u.userkey and ev.entitlementtypekey=et.entitlementtypekey and
et.endpointkey=ep.endpointkey and u.statuskey=0

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos