The query needs to search the History table to see with Tech changed the status to closed. Searching for a RESOLVED status for a particular TECH gives erroneous results, as I can close your ticket, but with this query you'd get credit for that.
is there a way to get this using the web interface or does this have to be pulled from the SQL database?
