KACE Product Support Question
Kace SQL Report to show all open tickets by week
09/09/2017 1423 views
I want to have a report that shows how many open tickets we have had per week for the past 12 months. If I was looking at the data for the last week, it would have to show how many opens tickets we had even for just last week. This would include tickets that were created weeks before, but it would exclude tickets that were closed this week.
So far I have a SQL query for only this week. This only shows tickets that are not closed this week. Some of the tickets in the result were created weeks ago but they are not yet closed.
COUNT(HD_TICKET.ID) AS NUMBER_OPENED,
HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
HD_QUEUE Q ON Q.ID = HD_TICKET.HD_QUEUE_ID
Q.NAME = "North America" and HD_STATUS.NAME != "CLOSED"