SharePoint 2010 Surveys - incomplete results

List the user of all Incomplete Survey Results

Incomplete results means that a user has pressed Save and Close in the Survey instead of Finish.

1. Find Site ID for the Survey Site
• Central Admin > Change Site Collection administrators
• Change site collection and the site id will appear in the URL
2. Find List ID for the Survey
• List Settings > Audience Targeting
• Copy the list ID from the URL
3. Run DB Query:

Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='siteid')
As UserName from USERDATA
where tp_ListId like 'listid' and tp_level = 255