osTicket: How to Query a Ticket Subject for a Report

  • osTicket can be a little obtuse. The title of a ticket is hidden in the ticket__cdata table, which by default is ost_ticket__cdata in the subject column.

    Take a quick peek and you will see it.

    SELECT * FROM ost_ticket__cdata LIMIT 4;

    Now, knowing what it is called and where to find it, you can use ost_ticket__cdata in your queries. Notice that there are two underscores together in that table name.