What tables to create database view for surveys?

[Allison3]

I'm needing to report on survey results based on the incident that triggered them.

We have a question asking about satisfaction of the incident where the user answers 1-5. I want to be able to have a report that will show me the average resolution answer per assignment group of the incident.

I'm thinking I need to create a database view to capture all this data and report on it together. I know I would use the incident table but I don't know what the other table would be. Assessment metric? Assessment Instance? Metric Type?

[Brian Lancaster]

I believe you already have this by using the Metric Result [asmt_metric_result] table.  You then just need to do Source is sys_id of your survey.

[Allison3]

This table seems to have a lot of the information I need. However, I haven't been able to find the assignment group for the incident that triggered the survey. I went to Metric but it doesn't have Related Field 1. I don't see where the related record (incident) is so I can dot walk to the assignment group of the incident.

[Scott Jordheim]

On that table, if you start at the Instance (+) column, then go to Task(+), it should allow you to see what you need. There may be other ways, but that is the way I've used.

[Brian Lancaster · Accepted solution]

You have to drill down a little bit.  You should see Instance which you can expand then task which you can expand.  Everything you are looking for should be in there.