Report on submitted responses

[Albert12]

Hi All,

After a vendor has submitted his/her responses and we go in the VRM module to review the responses, the options appear to only be "Show Follow Up responses" and "Show incorrect and un-scored responses" at the top for filtering, and "Internal Comment" and the Follow Up checkbox next to each question.  I wanted to confirm that clicking all the "Follow Up" checkbox just allows me to use the "Show Follow Up responses" checkbox.  It doesn't send an email to the vendor or show up on the vendor portal for them to provide additional information.  Is there a way to generate a report based on the items flagged or the incorrect responses?  Is there a way to generate issues on the flagged responses?  Based on my testing it appears that issues are independent of vendor responses.  Is there anything to associate an issue with an incorrect response?

Also when the vendor hits the button to submit his or her assessment, the message states "Submitted to ServiceNow."  Can this be customized to state my organization's name? If so, where? how?

Thanks,

Albert

[Jan Spurlin · Accepted solution]

You are correct that clicking the follow-up does  not generate any notifications.

You could probably generate a report - that may require creating a Database view where you combine tables.  All the assessment data uses the ServiceNow Platform Survey Assessment engine and sets of tables.  This is the same table set that is used to send out surveys to incident submitters, etc.  I haven't tried to fit all the pieces of this puzzle together, but it can be done.  It is all related.

 Issues are not linked to a specific question/answer in an assessment in the baseline. 

On the Vendor's Portal it is easy to change the "Submitted to ServiceNow" to another company name.  That is in a property. sn_vdr_risk_asmt.company.name

FYI - if you want to see ALL the files installed when you activate the Vendor Risk Mgmt plugin - try the following:

• In the App Navigator type sys_store_app.list
• • This will bring up a table that lists every scoped application for ServiceNow.
  • Search for Vendor Risk.
• In the Related Lists there is one called Installed Files.  There is a record for every installed file when the plugin is activated.  Use the filter to find what you are looking for.  There are 3 properties installed with this scoped app.
• • File on "Class".  If the value field only offers 4-5 options, reload the page.  There are really many, many options - Tables, Roles, Business Rules, Script Includes, etc.  

[Albert12]

Thanks again, Jan!  You're a rockstar!

[Albert12]

Thanks, Jan!  Updating sn_vdr_risk_asmt.company.name did update the "Submitted to [sn_vdr_risk_asmt.company.name]" prompt.

I currently only have the VENDOR RISK MANAGER ROLE within the VRM module. I don't have Administrative privileges for the ServiceNow instance, and don't have extensive database experience.  There has to be an easy way to get the responses from the questionnaire exported.  I don't seem to be able to find the appropriate table in the REPORTS module. I think I've tried using a LIST report for most of the sn_vdr_* Tables.

Additionally, it seems that while there's an option to download the SIG template, the resultant download is a blank template and isn't populated based on what a vendor has inputted into the system.  is there a way to export the vendor responses to the xlsm format?

[daniellethomson]

Hi Albert,

Were you ever able to figure out how to report on questionnaire/assessment responses? I'm able to get part of the information from the Survey Response table but not all. You wouldn't think exporting answers would be so difficult!