/build/static/layout/Breadcrumb_cap_w.png

Archive Report with Comments

Is there a way to build a report to display all tickets that have been archived and also display the details of the archived tickets?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: chrpetri 4 years ago
Blue Belt
0

You can use the report wizard to access archived tickets the same way like active ones by selecting the appropriate "Topic".
You'll see a separate topic for each queue of your service desk, they are alle named "Archive Ticket: <Queue Name Here>":


Z

The tickets' comments are avaliable for output, you can select them in the next wizard screen "Fields to display":

9k=


If you want a more custom report you can access the archived ticktes and all details by selecting from these tables:

HD_ARCHIVE_TICKET
HD_ARCHIVE_TICKET_CHANGE
HD_ARCHIVE_WORK

All other related tables are the same as for active tickets. Good news: the field names are the same as in the active tables, so you probably just need to switch table names, but not field names.

Don't be a Stranger!

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

Sign up! or login

Share

 
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