Pull the Inherent Assessment & Residual Assessment fields (UI pages) onto a report

RushicaB
Tera Contributor

Hey,

 

I am looking to include the following fields on a report but these are not fields on the form but the UI page. So, the fields are not available in the list of columns that can be dragged into a List type report. Is there any way these fields can be included?

 

Residual Assessment.pngInherent Assessment.png

1 ACCEPTED SOLUTION

Connor Levien
ServiceNow Employee
ServiceNow Employee

Hey @RushicaB ,

 

The responses to an advanced risk assessment are stored in the sn_risk_advanced_risk_assessment_instance_response table. If you want to report on the individual questions for both inherent and residual assessments you have to use this table as your source. This is due to the configurable nature of the Advanced risk assessment as it doesn't actually create a field on the Risk assessment table as you could end up with hundreds of columns.

View solution in original post

2 REPLIES 2

Connor Levien
ServiceNow Employee
ServiceNow Employee

Hey @RushicaB ,

 

The responses to an advanced risk assessment are stored in the sn_risk_advanced_risk_assessment_instance_response table. If you want to report on the individual questions for both inherent and residual assessments you have to use this table as your source. This is due to the configurable nature of the Advanced risk assessment as it doesn't actually create a field on the Risk assessment table as you could end up with hundreds of columns.

Thanks @Connor Levien . This was helpful and I am able to fetch the fields in the report now.