Capture the first person who resolved incident

[Michal Dycha]

I'm looking for your help.

I'm trying to create a report showing me a list of people who marked an incident as resolved but the incident was then reopened by someone else.

I have the list of all incidents with a Reopen count greater than 0 but the current “Assigned to” person’s name in most of the cases is not the same as the person who closed the incident in the first place.

Do you know how can I get the list of people who were the first to close the incident which was later reopened?

Thank you

[SanjivMeher]

The sys_audit table also has state change and it should give you the user who did it....You can probably run a script to query the audit table for those incidents and sort by created on and get just the first entry to get who resolved it.

[Michal Dycha]

Thank you. I'll try it.