We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

how to get requestable entitlement list under each endpoint

Venkata
New Contributor II
New Contributor II

Looking for list requestable entitlement under each endpoint

10 REPLIES 10

naveenss
All-Star
All-Star

Hi @Venkata 

Can you please elaborate more on what you're looking for?

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Venkata
New Contributor II
New Contributor II

Hi Naveen,

we have a requirement to get the data of the entitlements which are requestable under each endpoint.

E.g.,

EndpointName    count of entitlements visible for end user to request

SAP Application        15

 

@Venkata 

Use the below query

select ed.endpointname,count(ev.entitlement_value) from entitlement_values ev,entitlement_types et,endpoints ed where ev.entitlementtypekey=et.entitlementtypekey and ed.endpointkey=et.endpointkey group by ed.endpointname
Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Venkata
New Contributor II
New Contributor II

Thanks Naveen !

 

i am getting this error while using this query in Analytics.

Venkata_0-1690295410181.png

 

@Venkata  its missing the alias for count. Use below

 

select ed.endpointname,count(ev.entitlement_value) as 'Number of entitlements' from entitlement_values ev,entitlement_types et,endpoints ed where ev.entitlementtypekey=et.entitlementtypekey and ed.endpointkey=et.endpointkey and ev.status=1 group by ed.endpointname

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Hi @Venkata ,

Use below query to get count of requestable entitlement for each endpoint. Just small change in the query shared by @naveenss . It will give you only requestable entitlements since inactive are not be requestable.

select ed.endpointname,count(ev.entitlement_value) from entitlement_values ev,entitlement_types et,endpoints ed where ev.entitlementtypekey=et.entitlementtypekey and ed.endpointkey=et.endpointkey and ev.status=1 group by ed.endpointname


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

Venkata
New Contributor II
New Contributor II

Hi Naveen ,

This is working now, but can i know where we are checking the condition for entitlement is requestable or not.

 

Hi @Venkata ,

In Saviynt by default all the active entitlements are consider as requestable.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

@Venkata  in the query "ev.status=1" determines whether the entitlements are active or not. Value 1 stands for "active" entitlements. Inactive entitlements cannot be requestable.

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Venkata
New Contributor II
New Contributor II

Thanks Naveen !