What file to edit

cmadiam82

Hi All,

Any idea where I can find the file for this sql query?

SELECT A1.topic_idAStopic_id, AVG(TIMESTAMPDIFF(HOUR, A3.timestamp, A1.timestamp)) ASServiceTime, AVG(TIMESTAMPDIFF(HOUR, A5.created, A4.created)) ASResponseTimeFROMost_thread_eventA1 JOINost_threadA2 ON (A1.thread_id= A2.id) LEFT JOINost_thread_eventA3 ON (A2.id= A3.thread_idAND (A3.event_id= 1 AND A1.event_id= 2 AND A1.annulled= 0)) LEFT JOINost_thread_entryA4 ON (A2.id= A4.thread_idAND A4.type= 'R') LEFT JOINost_thread_entryA5 ON (A4.pid= A5.id) WHERE A1.timestampBETWEEN FROM_UNIXTIME(1619540107) AND FROM_UNIXTIME(1622132107) AND A1.topic_id> 0 GROUP BY A1.topic_id``

Thanks in advance!

ntozier

No where.

osTicket uses an ORM which generates the queries needed to get the information on the fly. That exact query does not exist anywhere in the core files.

The string ServiceTime exists in include/class.report.php though.

My guess is that this query is being generated by the Dashboard.