So our ticket count is getting a little off because of our email quarantine system. I would like to make a report that do not count tickets that have the subject ITSC Notice - Your Quarantined E-Mail Messages. I do not know coding well enough and hope somebody can help lol.
Select Top 1000000 htblticketcustomfield.data As Department,
Count(htblticket.ticketid) As [Total Tickets opened in 2021]
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketcustomfield On htblticket.ticketid =
htblticketcustomfield.ticketid
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Where htblcustomfields.labeltext = 'Main Department' And DatePart(yyyy,
htblticket.date) = '2021'
Group By htblticketcustomfield.data
