Create bulk completed attestation for Controls from Other system into ServiceNow

[prit123]

We have to create bulk completed attestation for Controls from other system into Servicenow. 

I couldn't find any script for creating attestation in asmt_assessment_instance table and Assessment Questions & answers in asmt_assessment_instance_question table. 

[prit123]

@Phil Swann - Can you please tell how did you achieved it? It would be helpful to know the approach you followed. 

[Connor Levien]

Hey @prit123 

The OOTB script include and function can be used to create the assessment instance within the system. Would suggest referring to its OOTB use in the below business rule

sn_grc.GRCAssessmentUtils().assessItem()

You will need to do this for each control you are loading an attestation for and then once it is created set the questions responses. You can do this all via a transform map with some before scripts. 

Alternatively if possible I would suggest moving to Smart Assessment Engine to do this as its a bit easier to do now and classic assessment instances are being replaced by Smart Assessments for all Risk products over the next few years.

[prit123]

@Connor Levien  Thanks for the information. I will go and check out the script and try creating a transform map to get the responses into ServiceNow.