Survey Attachment Location

[Steve147]

I've added a question to a survey that requires an attachment to be uploaded.
When I submit the completed survey I can find the answers to all the questions in the [asmt_metric_result] table but I can't find the file which was attached to the survey.

I checked [sys_attachment.list] and it shows images I've used in building surveys but none of the .TXT files which were uploaded by survey respondents.

Does anyone know where to find the files attached to survey responses?

[Sumanth16]

Hi @Steve147 ,

Can you check the "asmt_assessment_instance" table in the sys_attachment table.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Steve147]

Hi @Sumanth16 

The sys_attachment table is where I can find files I've used in the creation of my survey.
Banner and logos on the Intro page, etc...

But it doesn't have the files uploaded by respondents who take a survey which uses the "Attachment" control to let them upload a file.

[Shaqeel]

Hi @Steve147 

The files attached to survey responses in ServiceNow are stored in the sys_attachment table. However, they are not directly linked to the asmt_metric_result table. Instead, they are linked to the sys_survey_instance table.

1. Identify the sys_id of the survey instance (sys_survey_instance) for which you want to find the attachments. You can find this in the instance column of the asmt_metric_result table.

2. Go to the sys_attachment table (sys_attachment.list) and search for records where the table_name is 'sys_survey_instance' and the table_sys_id is the sys_id of the survey instance.

3. The list of attachments for the survey instance should be displayed.

Mark Helpful/Solution 🙂

Regards

Shaqeel

[Steve147]

Hi @Shaqeel ,
Thanks for the response. Apologies for the late reply.

I followed your instructions but had the same results I had above.
1. I went to the sys_attachment.list table

2. I used the sys_id of my survey instance to filter the list

3. It shows me the image that I attached to my survey, a logo which is displayed on the survey Introduction page

Unfortunately it doesn't show me attachments that respondents uploaded when they answered the survey.