Exporting all tickets from 11.0.273

Hey All, We plan to export all the live and archive tickets from Kace 11.0.273. Is there any guide or best practice to do this? We are trying to do it via the Report Wizard, but some columns/data are missing, and we need all the data pulled. Are there any useful guides for pulling it from the SQL database? I've combed through the site but can't find something that will let us pull all the data from the database, or may I am just missing the correct guide/post I appreciate any help you can provide.

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 months ago
Red Belt

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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ