Owner Count/ Ticket Report

[Sp39672G]

Hello,

Is there an easily available report that will show the number of owner changes a ticket goes through in its lifetime, or could someone please advise me how to create one? Eventually, will require to know who the owners are the ticket goes through, but the count is more important for now.

Thanks

[reneeb]

In the SQL Box (Admin Area):

Code: Select all

SELECT COUNT(*) + 1 AS owners FROM ticket_history th INNER JOIN ticket_history_type tht ON th.history_type_id = tht.id WHERE tht.name = 'OwnerUpdate' AND th.ticket_id = ...