osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Better Osticket Reporting
I have not tried every MySql tool to assist me to get better reporting or more detailed reporting for osticket but no luck.
I would like to ask if there is anyone who has created there own reporting script to suite there business needs , if yes please respond to this thread or contact me on jason.kleinhans[at]gmail[dot]com
what i would like to see is the following in my reports:
Tickets per department: let me give an example , tickets per deparment must not give me just figures i need detail. it must show me
TicketID | Department | Helptopic | Subject | ticket count , for the month , year , day and week.
and so i need the same for Tickets Per Staff , Tickets Per Client , Tickets Per HelpTopic
the detail will differ from report to report for the Ticket per Helptopic i need to know how many Networking or Application tickets did we receive per month , day , week and year and within this reports i need to have the staff list who worked on the ticket and when it was created and when it was closed