cancel
Showing results for 
Search instead for 
Did you mean: 

How can we exclude the entitlements that does not have owners in 'Entitlement Owner Certification'

Sanjeevini
New Contributor
New Contributor

Hi,

During Entitlement Owner Certification, I want to exclude those entitlements that does not have owners.

How can I achieve this, if this can be achievable through advance query.

Can I get the sample query?

 

Thanks,

Sanjeevini 

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Try below query in Entitlements Query to filter out entitlement with owner are selected 

ev.entitlement_valuekey in (select distinct eo.entitlement_valuekey from com.saviynt.ecm.identitywarehouse.domain.Entitlement_owners eo )

Manu269
All-Star
All-Star

Can you please try by selecting Select Certifier option as Select From Manual Query.

This feature checks and validates the manual query (with alias and without alias) and displays the validation messages, appropriately before creating a campaign. 

Manish Kumar

Sanjeevini
New Contributor
New Contributor

Thanks for the responses. Below query worked

entitlement_valuekey in (select distinct eo.entitlement_valuekey from Entitlement_owners eo )