/build/static/layout/Breadcrumb_cap_w.png

Listing of ticket IDs in Archive

I need to do an Archived ticket review. When I create a report using the "Create Report" action in the Archive Ticket screen with all tickets and all queues selected, I get a report with many duplicate ticket IDs. I can't do an export because it limits it to 5000 entries. KACE version is 11.1.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 months ago
Red Belt
0

try going with

SELECT HD_ARCHIVE_TICKET.ID,

       HD_ARCHIVE_TICKET.TITLE,

       HD_ARCHIVE_TICKET.SUMMARY,

       HD_ARCHIVE_TICKET.HD_PRIORITY_NAME,

       HD_ARCHIVE_TICKET.HD_IMPACT_NAME,

       HD_ARCHIVE_TICKET.SUBMITTER_USER_NAME,

       HD_ARCHIVE_TICKET.HD_STATUS_NAME,

       HD_ARCHIVE_TICKET.HD_QUEUE_NAME,

       HD_ARCHIVE_TICKET.HD_CATEGORY_NAME

  FROM HD_ARCHIVE_TICKET HD_ARCHIVE_TICKET

As a starter, then add in any other custom fields that you need etc etc

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