From either Dataverse or CDS I need to report whether a survey is active or not. Ideally, I want to use the "Accept responses" toggle which is in the "Responses" section of the "Distribution" settings. My need is to be able to report on surveys that are active and not and use a switch within Customer Voice to control this. I cannot find any way of doing this. Within the msfp_survey table I can see fields such as statecode, statuscode and statusname, however, this seem to always be set to "Active" irrespective of any actions that are taken within Customer Voice itself. I'm stuck.

Report
All responses (
Answers (