Survey on the sys_user table

[Javier19]

Hello!

The company for what I work was paying to a third party to make a yearly survey to all of our active users. We want to replicate that in ServiceNow, but it should be sent every 6 months. The problem that we are facing is how to configure the trigger condition properly. We have LDAP configured and an integration with Salepoint, so I believe that the field that we should use for User field in the sys_user table should be Updated, and the condition should be Active - True. But the Updated field is not being shown as an option in User field, in a matter it shows the related lists of the table, and only Manager and Company contact are selectable.

The other quesion would be what should I do to make it run every 6 months, or if there is a way to trigger the survey manually.

I tried searching, but I couldn't find anything in the community. Most of the survey posts are related to the Incident table.

[Voona Rohila]

Hi @Javier19 

Take a look at 'Recipients List' concept, This creates a m2m table and that table can be used in your survey Conditions Table 

https://www.servicenow.com/docs/bundle/yokohama-servicenow-platform/page/administer/survey-administr...

[Javier19]

Thank you for your quick reply Rohila! I have tried that, seems pretty simple to configure (please see the image), but when I click on Refresh Recipient List, it doesn't add any recipient. Could it be because we have between 14-15k users?

[Voona Rohila · Accepted solution]

I would suggest use the User field as 'Sys ID' instead of 'Active' field and refresh the list.( You need user details and on survey you can use this user field)

[Javier19]

It worked, thanks!