Query to return ticket details with custom fields

Hi,
I would like to query directly the mysql tables and retrieve into Excel Ticket details including custom fields.
Can anyone offer the appropriate SELECT with proper joins?
Thanks in advance,
G.

If you can use the web UI you can get search results in CSV format? A SQL query would be quite complicated I think

I am unable to include custom fields in the webui queries
Perhaps I need training?

You need to add a queue to your query, then in the search results columns you can select a CF

1 Like