Notification

Icon
Error

New chart report that gives departments total tickets but ignores tickets with a certain subject.

Posted: Tuesday, September 14, 2021 10:08:07 PM(UTC)
Tythesly

Tythesly

Member Original PosterPosts: 35
1
Like
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.

Code:
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
Tythesly
#1Tythesly Member Original PosterPosts: 35  
posted: 10/1/2021 4:03:06 PM(UTC)
Anybody?

Active Discussions

Lansweeper Chrome 95 Audit
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 11:14:31 AM(UTC)
Lansweeper Detecting and Reporting on Programs in Apps & Features
by  LANGuy  
Go to last post Go to first unread
Last post: 10/18/2021 6:09:11 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 not working
by  jmm25   Go to last post Go to first unread
Last post: 10/18/2021 12:48:41 PM(UTC)
Lansweeper AD DistinguishedName of Computer object
by  elKastr0nom   Go to last post Go to first unread
Last post: 10/14/2021 6:52:50 PM(UTC)
Lansweeper Report if Credential Guard is active
by  ericatbrandmauer  
Go to last post Go to first unread
Last post: 10/14/2021 10:28:15 AM(UTC)