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

Summary report with ticket status


I created a custom list where I defined various "ticket status" values.

I can email ticket status using %{ticket.ticketstatus} variable.

Question:  Is there any way to generate a report that would show ticket number, ticket description and ticket status for all open messages?
This will be very useful to analyze trends and provide management with summary reports

It is not important if it done via direct SQL query against the database, or through the web page.



  • like:
    SELECT * FROM ost_ticket WHERE status='open';

  • thanks :)  that was easy
  • Very welcome. :)  I'll close this thread but please feel free to start a new one if you have another question.
This discussion has been closed.