Exporting a completed Vendor Risk Assessment questionnaire

andrewgreen · ‎10-30-2018

We have vendors who are completing our Assessment Questionnaires. Is there a way to easily export the completed assessment questionnaire with the vendor's responses?

We need the ability to send the completed assessment questionnaire to an internal business user as a PDF, Excel, etc....

Jan Spurlin · ‎04-03-2019

Hey guys - Assessment data is stored in multiple tables. What you probably need to do is to create a database view that combines all the necessary tables and then you will have a source for your export. But you are talking about combining several tables.

This diagram will get you part of the way there - but I haven't tried to identify the table names where the answers are stored for a specific vendor. And there is one table missing - the for Assessment Categories - I need to add that to this diagram

View solution in original post

Jan Spurlin · ‎11-01-2018

Why not get the user access to the assessment inside of ServiceNow? The options to view assessment answers is very extensive and gives them a number of filtering options on correct answers or answers that were flagged. This would be a better user experience.

Having said that you can export it. The answers are stored in a table. You may have to create a database view that combines the question and the answer into a single table or you might be able to dot walk it - but I'm going to go back to giving the user access to read it in the ServiceNow platform.

andrewgreen · ‎11-01-2018

Thanks Jan!

Unfortunately due to licensing in our contract, we would have to license each of the users in order to get them access to the tables that contain the assessment responses, so we may consider this if we are not able to find a solution that would work for us that would be more cost effective.

Thanks again Jan!

daniellethomson · ‎04-03-2019

Andrew- Were you ever able to figure this out? I can get part way there from the Assessment Instance Question table or the Survey Response but can't seem to get all together.

Thanks!

Danielle

andrewgreen · ‎04-03-2019

Hey Danielle,

I did not find a useful way of exporting this.

I exported the details from the assessment instance into an excel file and then manipulated the data (changed the 0 and 1 responses to 'No' and 'Yes' so it would useful data to the internal end user.

Not ideal and it is time consuming, but it works for now.

Hope that helps!