Notification

Icon
Error

Helpdesk: Count of tickets created per year and month (Built-in)

Posted: Wednesday, August 9, 2017 10:58:37 AM(UTC)
Nick.VDB

Nick.VDB

Member Lansweeper Developer Administration Original PosterPosts: 251
1
Like
Added in v.6.0.100

The report below gives back a count of the tickets that have been created during each year/month.

The report will only take count tickets that meet all of the following criteria:
  • The ticket has not been set to ‘Ignore’

Code:

Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
  DatePart(mm, htblticket.date) As Month,
  Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
  DatePart(mm, htblticket.date)
Order By Year Desc,
  Month Desc
blasto
#1blasto Member Posts: 19  
posted: 3/3/2020 8:08:57 PM(UTC)
Originally Posted by: Nick.VDB Go to Quoted Post
Added in v.6.0.100

The report below gives back a count of the tickets that have been created during each year/month.

The report will only take count tickets that meet all of the following criteria:
  • The ticket has not been set to ‘Ignore’

Code:

Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
  DatePart(mm, htblticket.date) As Month,
  Count(htblticket.ticketid) As TicketsCreated
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
  DatePart(mm, htblticket.date)
Order By Year Desc,
  Month Desc


Thank you so much!

Active Discussions

Lansweeper mail reports
by  Andy.S   Go to last post Go to first unread
Last post: 7/1/2022 2:38:18 PM(UTC)
Lansweeper Adding an "Employee ID" column to an asset report
by  ABaker  
Go to last post Go to first unread
Last post: 6/30/2022 3:06:54 PM(UTC)
Lansweeper Firefox 102 & ESR 91.11
by  Esben.D   Go to last post Go to first unread
Last post: 6/30/2022 8:12:07 AM(UTC)
Lansweeper Performance report not shows result
by  NoraD  
Go to last post Go to first unread
Last post: 6/28/2022 7:52:27 AM(UTC)
Lansweeper Duplicate AD Users
by  Randy Costa   Go to last post Go to first unread
Last post: 6/27/2022 5:25:04 PM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Adrian Scott  
Go to last post Go to first unread
Last post: 6/22/2022 5:34:51 PM(UTC)