1 of 1 people found this helpful
You will need to create the query on the "Closure" object and not Incident. You should be able to pull the Incident data from Closure. Give that a shot. Then the "Created By" will be the person who created the closure.
I have left it as currentassigneduser so technically we are reporting on who reolsved the incident and not who completed the close task. I have tried reporting on the last update by but as soon as I add the Tile or name to the query it stops working. For now I will leave it as is as the credit needs to go to the resolving analysts anyway as this is the technical resolution the close task anyone can do.
You could write your query against Resolutions then. I did that before and that's how the analyst got credit plus I was able to get all the information from the ticket itself. If you do it from Incident you'll just need to make sure you pull the resolutions information in (created by, etc..) then base your numbers on that. Last updated by could cause issues because if anyone opens that ticket and changes the slightest thing and saves it they they will get credit.
We use resolution as the end point for an incident and then a bulk action closes the incident. By looking at who created the resolution you will get the last analyst to resolve the incident. I say last analyst because sometimes an incident gets re-opened and there will be 2 analysts. Service Desk will generally show the last resolution making things easier. Seems odd to use the "created by" but it is referring to the analyst that created the resolution. This analyst will not change due to surveys, notes, closing, etc so it's a good value to use.
You also use the date created for the date and time an incident was resolved. Again, date created refers to the date and time the resolution was created.