EO Campaign - Include Active Users with accounts and also accounts with no user association

[SPP]

Hi All,

We have applications with regular accounts( associated with users) and service accounts (not associated to any user).

Need to launch Entitlement Owner campaign for the below cases

1. Active users with active accounts

2. Active service accounts not associated with any user.

If I add statuskey='1' in the Users Query, the second case is failing and not including service accounts in the campaign. How can we make sure both the cases are working?

Thanks

[NM]

@SPP inactive users will be having inactive accounts so I believe they will be automatically removed from the campaign and you don't have to apply filter on users query.

[rushikeshvartak]

• Remove filter as inactive users are by default ignored in EO

[SPP]

@NM @rushikeshvartak  By default it includes both active and inactive users. There are some active accounts for inactive users. Those should not get included.

[NM]

@SPP add below query in account query

accountkey in (select ua.accountkey from user_accounts ua, users u where u.userkey=u.userkey and u.statuskey=1) or 

accountkey not in (select ua.userkey from user_accounts ua)

[SPP]

@NMI still see inactive users showing up in the campaign after the accounts query is added as mentioned.

[NM]

@SPP add only this and see.

accountkey in (select ua.accountkey from user_accounts ua, users u where ua.userkey=u.userkey and u.statuskey=1)

[SPP]

@NM It shows up only active users now but the service accounts are missing.

[rushikeshvartak · Accepted solution]

accountkey in ((select ua.accountkey from user_accounts ua, users u where ua.userkey=u.userkey and u.statuskey=1) union  (select a.accountkey from accounts a where a.endpointkey in (1 ) and a.accountkey not in (select accountkey from user_accounts)) )