KACE Product Support : Custom report organized by queue.

Custom report organized by queue.

I'm trying to make a report that shows a yearly number of tickets submitted and organized by queue. We're trying to pinpoint which queues get the most tickets submitted to them over the course of the year. Anyone have any ideas?

2 Comments [ + ] Show comments

Are you looking for the initial queue for the ticket or the resulting queue? In our case, we want the resulting queue as the bulk of our tickets are created by our student aides in our Help Desk queue and forwarded to other queues as appropriate. - grayematter 9 years ago
- The initial queue should work for what I'm looking to do with it. We have our users submitting their own tickets a majority of the time and want to identify the most used queues. - kharrison 9 years ago
  - Though, the resulting queue could work as well. I'd just need to look at the output to say for sure. - kharrison 9 years ago
I've been able to modify the 30 day default report for closed tickets to show me tickets for the year and give me the queue id, but I've yet to figure out how to link that back to queue name. - kharrison 9 years ago
- You need to add a join to the HD_QUEUE table:
  JOIN HD_QUEUE on HD_QUEUE.ID = HD_TICKET.HD_QUEUE_ID
  
  You can then select HD_QUEUE.NAME for the queue's name. - chucksteel 9 years ago
  - Thanks for the solution. My syntax was apparently off on joining the table. - kharrison 9 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

KACE Product Support Questions

question

Custom report organized by queue.

Answers (0)

Posted by:

View more:

Related Questions

Related Links

Related Posts

KACE Product Support

Custom report organized by queue.

Answers (0)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share