Count of Tickets Closed per Year and Month

Find the Number of Helpdesk Tickets Finished per Month

Report on the number of tickets that were handled in a given month. Keeping track of the number of tickets that come through the helpdesk is an important metric when it comes to forecasting and for estimating the amount of work. The report gives an overview of the number of closed tickets per year and month. This way you have proof of the number of tickets finished which can be incorporated in a monthly review.

Count of Tickets Closed per Year and Month Query

Select Top 1000000 TicketClosures.Year,
  Count(TicketClosures.ticketid) As TicketClosed
From (Select Distinct Top 1000000 htblhistory.ticketid,
        DatePart(yyyy, As Year,
        DatePart(mm, As Month
      From htblhistory
        Inner Join htblhistorytypes On htblhistorytypes.typeid =
        Inner Join htblticketstates On htblticketstates.ticketstateid =
      Where In ('Status changed',
        'Note added and state changed', 'Internal note added and state changed')
        And htblticketstates.statename = 'Closed') TicketClosures
  Inner Join htblticket On htblticket.ticketid = TicketClosures.ticketid
Where htblticket.spam <> 'True'
Group By TicketClosures.Year,
Order By TicketClosures.Year Desc,
  TicketClosures.Month Desc

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting