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

Exclude entitlements with no accounts in entitlement owner campaign

SudheerKaneti
New Contributor II
New Contributor II

Hi Team,

We are trying to exclude entitlements which are not having accounts in them in entitlement owner campaign.

We have tried below queries in Account entitlement 1 Query in Advanced query, but none of them worked.

1. ae1.entitlement_valuekey is not null 

2. ae1.entitlement_valuekey>0

3. ae1.entitlement_valuekey is not null and ae1.accountkey not in (select accountkey from accounts)

May anyone please help us with the above.

Thank you,

Sudheer Kaneti.

 

 

2 REPLIES 2

dgandhi
All-Star
All-Star

Add below condition in Advance Config and try.

dgandhi_0-1690834457868.png

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

rushikeshvartak
All-Star
All-Star

try below query and change filters as per your need

select * from(

 

select ev.entitlement_valuekey ,ev.entitlement_value,
(select count(* ) from account_entitlements1 ae1 ,accounts a where ae1.entitlement_valuekey=ev.entitlement_valuekey and 
a.accountkey=ae1.accountkey and a.status in (1,'Manually Provisioned') and a.accounttype ='A'

 

)noofaccountsassignedwithent
from entitlement_values ev where 
ev.customproperty30 Like 'True' and ev.status=1
and entitlementtypekey=121 )data where noofaccountsassignedwithent=0


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