User Manager Campaign Scope Application

[HichamElk]

Hello,

We would like to launch a certification campaign for managers on a specific application.

We have several applications. When we select an application in the campaign configurations, and choose “Select All Certifier”. The campaign is launched for all Saviynt managers.

We can make a query to select managers on an application, but we'll have to change the application variable each time. Is there another way?

[rushikeshvartak]

Can you share current config and screenshot

[HichamElk]

[rushikeshvartak]

Can you elaborate or explain current configs 

We can make a query to select managers on an application, but we'll have to change the application variable each time. Is there another way?

[HichamElk]

In the Select certifier field, i guess that we could make a query to only select managers for one or more applications. 

For exemple : SELECT managers FROM users WHERE application = xxx (just an idea) 

Or do you have recommandation on how to select only the managers of the application in scope 

[sakshibansal]

You can add a query in Advanced configuration to filter the users who have account in that particular application.

Thanks & Regards

Sakshi Bansal

[HichamElk]

I will try, 

So the application box is useless ? If i chose one application, it will still create the campaign for all managers of all applications ? And we have to enter a user query right ? 

[rushikeshvartak · Accepted solution]

Use below query 

u.id in (select m.id from User_accounts ua,Accounts a,Users u1,Users m,Endpoints e where ua.userkey=u1.id and ua.accountkey=a.id and m.id=u1.manager and e.id=a.endpointkey and e.endpointname='Azure_AD' )

[HichamElk]

Works well, 

Thank you @rushikeshvartak !