Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Events in the DB

Hi guys

Where do you store the ticket thread events in the database?  I need to report on how many transfers are happening per department for a specific period of time and I'm struggling to find this info.

Any help would be much appreciated.


  • I am running osTicket v1.10.1 on Ubuntu 14.04 LTS.  php version is 5.6.
  • SELECT t1.`name`, t2.`state`, t2.`count` FROM
    (SELECT `id`, `name` FROM `ost_department`) t1
    (SELECT `dept_id`, `state`, COUNT(*) AS `count` FROM `ost_thread_event`
    GROUP BY `dept_id`, `state`) t2
    ON t1.`id` = t2.`dept_id`
    WHERE t2.`state` IN ('transferred')
Sign In or Register to comment.