Skip to main content

How can I export my tickets? - Knowledgebase / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. For the most up-to-date version, see: Download/Export Ticket Results as CSV

How can I export my tickets?

Authors list

For up to about 20,000 tickets, you can run this query from the Report Builder:

 

DISPLAY TABLESELECT tickets.*FROM tickets

 

If you have added a lot of custom ticket fields, this may not work (Reports can only include up to about 55 fields). In that case, run a query which specifies the ticket fields individually. Replace SELECT tickets.* in the query above with:

 

SELECT tickets.id, tickets.subject 

 

The full list of ticket fields is available on the Reports Manual.

You will then be able to export the result in PDF or CSV format.

If you have more tickets than the Report Builder can output, you will need to export your tickets using the DeskPRO API (requires programming skills).

Helpful Unhelpful

49 of 87 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?