Report on Risk Assessment answers

[Mickey_Cegon]

I need to create a report that gives me the answers to the Risk Assessments on Change Requests. No matter how I do this, I'm coming up empty. I see that the responses are in the survey_response table, but I don't see where the Task number field is. I see that on the Change Request, the Risk Assessment Related List is the task_assessment table. But, if I write a report on the task_assessment table, I only get the regular Helpdesk survey responses. I really would like to do something where my Change Manager can see all the responses for a Risk Assessment, grouped by Change Request Number. I would have liked to do a Pivot Table similar to the Helpdesk Survey pivot table reports, but the answers to my Risk Assessment are not numerical, they are Yes/No and High/Med/Low, etc.

Would I need to create a Database view? I see the Task number when I look at the Risk Assessment Related List, but how do I tie that together with the actual answers to the Risk Assessment?

Any help would be appreciated.

Mickey Cegon
FBL Financial Group, Inc.

[jim_holthaus]

I created a view that joined task_assessment, survey_instance, change_request, and survey_response. My view is modeled on the standard task_survey_detail view that comes out of the box. I was then able to report against the view to get a listing of each risk assessment question (and its answer) grouped per change request. I have attached screenshots showing the sample report and how I configured the view. I hope this helps!

[Allison3]

I know this post is pretty old but I'm needing to do exactly this. Does this still work the same in newer versions of ServiceNow? We are currently on Eureka.

[Allison3]

I did this and now it's running extremely slow on the report. How can I limit these to pull in only certain fields? I tried to add view fields under the table but then the report doesn't seem to run.

[Lynette Sandlin]

I just got a requirement to do this and this worked perfectly! Thank you very much.