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

[Sanjeevini]

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 

[rushikeshvartak · Accepted solution]

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]

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. 

[Sanjeevini]

Thanks for the responses. Below query worked

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