Link asmt_metric_result to incident table

[donpa]

I created a survey that automatically is sent to the caller listed on the incident when the incident is closed.   That caller answers the survey and the results are put in the asmt_metric_result table.   My manager wants a report that includes who closed the incident but I see no link from asmt_metric_result back to the incident table.  

Manually I can see each record ex... INCxxxx is closed and AINSTxxxx is the related to the closed INCxxxx just don't see a way to link back to the incident table.  

Does anyone know how to link these tables so I can retrieve the closed_by value from incident table?

Thanks

[Travers M]

The assessment is created by the person that resolved the incident so I use created by on the assessment.   The only time this could end up biting you is if the incident is self resolved by the requester.

[donpa]

Hi Travers,

Thanks for the reply but still don't see what I need, what I am seeing is the survey is created by the caller so the created by on the assessment is the caller. I am looking for who closed the incident.

Don Pavelka

Technical Analyst II

HSHS Service Support Building (SSB)

1665 Yellow Briar Dr.

DePere, WI 54115

External Number: 920-433-8083

Internal Extension: 48083

[Travers M]

That's my fault, I use created by on the Assessment Instance table.   In my instance, that ends up being the person that was resolving the incident.

[donpa]

No worries will keep trying to figure it out.

thanks

Don Pavelka

Technical Analyst II

HSHS Service Support Building (SSB)

1665 Yellow Briar Dr.

DePere, WI 54115

External Number: 920-433-8083

Internal Extension: 48083