How to find user who have not completed the survey in database.
· At first find the content database where we have the survey list.
· Then look for the survey name and copy the corresponding tp_id
· Now run the query
SELECT *
FROM AllUserData
WHERE (tp_ListId = 'eda75dbc-f91b-4a1f-a7a2-a9ef39d664ab')
· It will give all the data is survey
· Now look at the end of the table you will find tp_CheckoutUserId if it null thenit is completed and if some value is there then it is not completed.
· Copy the tp_author for all those who are not completed
· Now open userinfo table and check the tp_login corresponding to tp_id
· These are the users who still need to complete survey.