AnsweredAssumed Answered

OpenDB query to find out who has completed an Enterprise survey?

Question asked by lee.mcminn on Jun 28, 2018
Latest reply on Jun 29, 2018 by hxnguyen

Several have posted the need for Blackboard to provide a way to see who has or hasn't completed an Enterprise survey.  If all the data is collected we should be able to create a query that lets us pull the data.  Even if the survey is set to be anonymous.  We are not looking for the answers to the survey questions to be matched up with the person that completed the survey.  We just need to know who has and hasn't responded to an Enterprise survey.  There must be some record of that, otherwise the reminders would not work properly. 

So, can anyone tell me which tables and fields hold the data we are looking for.  I've looked through all the tables that have to do with surveys and I can find the surveys, the response periods (deployments), and even the number of responses.  What I cannot figure out is how to tell who responded and who didn't.

Any ideas?

Lee McMinn

Outcomes