List of tickets transferred from one owner to another

[chaitanyacda]

Greetings,

I would like to know if there is a way to report or list all tickets which were owned by an agent and then transferred to another?
We are looking for a way to find out some performance metrics for our agents and like to know this.

Thanks and Regards
Chaitanya A.

[crythias]

Code: Select all

SELECT ticket.tn, users.login as 'From', ticket_history.name as 'To'
FROM ticket_history
LEFT JOIN ticket ON ticket.id = ticket_history.ticket_id
LEFT JOIN users ON users.id = ticket_history.owner_id
LEFT JOIN ticket_history_type ON ticket_history_type.id = ticket_history.history_type_id
WHERE ticket_history_type.name =  "OwnerUpdate"

Add other fields as necessary.