Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/14/2024 06:57 AM
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?
Solved! Go to Solution.
08/14/2024 07:01 AM
Can you share current config and screenshot
08/14/2024 07:08 AM - edited 08/14/2024 07:10 AM
08/14/2024 07:11 AM
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?
08/14/2024 07:24 AM - edited 08/14/2024 07:25 AM
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
08/14/2024 07:58 AM
You can add a query in Advanced configuration to filter the users who have account in that particular application.
Thanks & Regards
Sakshi Bansal
08/14/2024 08:07 AM
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 ?
08/14/2024 08:18 AM
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' )
08/14/2024 08:27 AM
Works well,
Thank you @rushikeshvartak !