How to enable to export responses from assessment type questionnaires?

[ChuanYanF]

Dear experts,

I would like to enable the export responses features for the internal assessments being done. How should I do so? Currently there is no feature that allows us to export as excel or even as pdf.

[Matthias Ferstl]

Hi @ChuanYanF 

this looks like a Job for a custom Script based on an UI Action.

You can build an export script that acesses the Asessments Instance Questions (asmt_assessment_instance_questions) that are linked (use the "instance" field on question records) to a the speciffic assessment instance (asmt_assessment_instance). In the question record, you can find the Metric and value.

There are APIs (for example for .pdf generation), that you can find in the documentation.
Also you can find some imformation here:
ServiceNow PDF Generation API Magic | Learn the po... - ServiceNow Community

Kind regards,

Mat

Would be great if you could mark the answer as helpful (if it was) and correct 

[Matthias Ferstl]

Hi again, i just saw that it seems you are trying to export for TPRM.
Exports there are possible within VRA Records (sn_vdr_risk_asmt_assessment).

Take a look at the related lists and click on "View responses"

There you can download the template as an vendor, or "export" responses 

This is (afaik) only part of TPRM and just in the VRA Records

   

kind regards

[ChuanYanF]

Hi matthias, this is for external assessment ya, but for my case I am asking for records in sn_vdr_risk_asmt_internal_assessment, which does not have the export responses button. How do I enable it or add that feature to my case?

[Matthias Ferstl]

Hi

There is no OOB functionality for that.
You can either try to use my first answer (just the tables are different ones)

or you can try to recreate this on the according UI Pages.