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.
Answers (1)
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
