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 Upgrade Win 10 build to version 2004
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 12:11:55 AM(UTC)
Lansweeper Sort Reports by Last Changed
by  LANGuy  
Go to last post Go to first unread
Last post: Yesterday at 7:02:23 PM(UTC)
Lansweeper Windows Encryption Method
by  elKastr0nom   Go to last post Go to first unread
Last post: Yesterday at 6:02:07 PM(UTC)
Lansweeper Built in report - AD Password Expired
by  FezUSA  
Go to last post Go to first unread
Last post: Yesterday at 3:12:17 PM(UTC)
Lansweeper Helpdesk Dashboard Shared Tab
by  mark chamberlain   Go to last post Go to first unread
Last post: Yesterday at 2:32:20 PM(UTC)
Lansweeper Uninstall an software with Password
by  CyberCitizen   Go to last post Go to first unread
Last post: Yesterday at 6:20:28 AM(UTC)
Lansweeper Scanning for Events in Applications and Services Logs
by  Geoff P G  
Go to last post Go to first unread
Last post: 10/20/2021 5:22:11 PM(UTC)