osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Help with MySQL query to pull data for reports from osTicket 1.8.1
I am happy to have discovered osTicket and I am about to introduce it to my IT dept and another non-IT dept in my organization. I am running osTicket 1.8.1. One important usage is for managers to generate reports from the MySQL data generated by osTicket. I know there's a MOD out there for reports but I am wanting to know if someone has experience with queries from osTicket that would be appropriate. I basically want to run queries to pull "report" data and dump it into a csv/Excel file to make it "pretty".
For example, I would probably want to pull data for tickets for a given date range (start/end date) including:
*date of ticket creation
*department (assigned ticket)
*user/customer name (who submitted ticket)
*title of ticket
*body of ticket
*staff member (who closed the ticket)
*date/time when ticket closed
If any can point me to some queries to get me started I would appreciate it greatly :). I am a novice with MySQL but I think if someone could give some examples I could tweak them to suit my needs.
TIA and cheers,