Thanks! I realized I had to connect to the Orion DB which is MS SQL. Now I need to figure out this table structure. Any clues on popular tables to start with!
Glad you got it! I find SQL to be more robust, so I go the Custom SQL Query route to specifically define the requirements of the report.
That being said, some of the bread and butter tables will still be:
If you use a lot of custom fields, you'll also find TICKET_CUSTOM_FIELD invaluable!