Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Campaign Query

AshishDas
Regular Contributor II
Regular Contributor II

Hi,

We have a requirement to relaunch a campaign for all users whose campaign response was ' No Response'.

We have selected to revoke tasks for certified users on campaign expiry and hence, for users for whom 'No Response' was selected, we need to relaunch a new campaign.

While launching a new campaign we have an option for selecting the set of users via the Advanced query. Can I get the query for all users for whom no response was selected from the previous campaign?

7 REPLIES 7

Saathvik
All-Star
All-Star

You can actually download a summary report from previous campaign and filter by certified column as 'No Response'. Summary report will have below sheets

  1. Certification Summary Report
  2. List of Accounts for Certification
  3. Deprovision Tasks for Certification

You can use 2nd sheet List of Accounts for Certification to find out of the list which has no response


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Sorry ignore my previous comment, I jumped too early Can you confirm which type certification you are talking about


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Which campaign ?


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

AshishDas
Regular Contributor II
Regular Contributor II

The User Manager Campaign

Try this

select u.username from campaign cm inner join certification c on cm.id=c.campaignkey inner join certification_user_status cus on c. certkey=cus.certkey inner join certification_user cu on cus.cert_userkey= cu.cert_userkey inner join users u on cu.userkey=u.userkey where cus.certified is null and cm.campaign_name='<campaign_name>'

You can validate the output of this query by comparing it with summary report as previously mentioned


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

AshishDas
Regular Contributor II
Regular Contributor II

This works. Thanks!

Can you share exact query used in campaign


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