query for 'ticket activity' in osTicket database

Question

ticket activity osTicket

how can i get data like that table, from database osTicket?

Answer 1

There is a lot of data on the picture. Which of them do you want exactly? I have a few queries for osticket usage stats.

For example: This query retrieves count of opened tickets by date, that have specific helptopic "topicname".

SELECT DATE(ticketTbl.created), count(*) 
FROM osticketdb.ost_ticket AS ticketTbl
    INNER JOIN osticketdb.ost_help_topic AS topicTbl
    ON ticketTbl.topic_id = topicTbl.topic_id
WHERE topicTbl.topic = 'topicname'
GROUP BY DATE(ticketTbl.created);