users that have the surveys in the incomplete or saved status

While working on Surveys on Sharepoint, the strange question that we generally face is that, the number of surveys is different than the total surveys shown in the list.
Mostly, the reason is “incomplete surveys”. Also, we are asked many times about the list of users that have the surveys in the incomplete or saved status but unfortunately there is no direct method in the SharePoint UI which allow you to see this.

Today I came across the same question where list had 4 survey count but in the list there was not any survey response and the mystery again was incomplete surveys but it raised the same question, which users are these that have not completed the survey?

While moving through different forums, got the following SQL statement which can be run against the content database of the site collection and get the user name.

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

Now, SiteID and LISTID are the fields that needs to be inserted.

1. For Site ID, Open Central administration -> application management->site administrators-> Select the site collection and Site ID is shown in the URL.
2. For List ID, Open the List with Admin account, click on settings->target Audience settings. LIST ID is the in the URL like {LISTID}.

Hope this will Help