Campaign with only the Application Role

[akhilvatsa]

Hello,

We have a requirement to create a campaign for only Application Role. We have selected 'Objects to be included in Certification' as 'Application Role'. However, the certification is being launched for all the users, even if they don't have an Application Role assigned.

Is there any way we can only start certification for users having Application Role? 

[Sivagami]

@akhilvatsa - Objects to be included in Certification is only Application Role & you excluded Account, Entitlement?

[akhilvatsa]

Hi @Sivagami that is correct, we have only kept Application Role

[Sivagami]

Thanks @akhilvatsa!

What type of campaign you are trying to launch? -> User Manager or Role Owner

Does your application roles follow any naming convention? 

Have you selected 'All' in the 'Applications'?

[rushikeshvartak]

• items to be included
•  
• Advanced Configuration
•  

[akhilvatsa · Accepted solution]

Thanks for the responses, unfortunately it didn't work for us. 

The following query on Users worked: username in (select distinct username from users where userkey in (select ru.userkey from role_user_account ru, roles r, endpoints e where r.rolekey=ru.rolekey and r.endpointkey=e.endpointkey and e.endpointname='Endpoint A'))