Scripting

You will need to write a custom report to get the data that you need. The data that you need and what you need it for will be key to how complicated your report will need to be.

To start you need to look in HD_TICKET table, that will hold the majority of your data, but if you want to display the text of related data, for example the category, status or submitter then you will have to increase your report. In HD_TICKET for example HD_TICKET.HD_SUBMITTER_ID holds the ID of the submitter, but you will need to pin HD_TICKET to the USER table using that submitter ID. Same with category, status etc

If you then want the history of changes within the ticket you will need to look at incorporating the change table.

I hope that gives you a taste, connect via ODBC and use an SQL workbench style product.