Notification

Icon
Error

Top 10 users submitting tickets - Top 10 users submitting tickets by month and year

Posted: Wednesday, July 17, 2019 9:29:44 PM(UTC)
LGuth

LGuth

Member Original PosterPosts: 5
0
Like
I would like to have a report showing the top 10 users that have submitted tickets by month and year.
I'm not real savvy on writing code.
Could someone help me?

Linda Guth
====

Maybe this report below that shows the top Ticket Types can be modified to show User Names instead?

Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
'../helpdesk/icons/' + htbltickettypes.icon As icon,
htbltickettypes.typename As Type,
Count(htblticket.ticketid) As TicketCount,
Cast((Count(htblticket.ticketid) / Cast(TicketCount.Amount As decimal) *
100) As decimal(10,2)) As [Type%]
From htblticket
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
htblticket.tickettypeid
Inner Join (Select DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
Count(htblticket.ticketid) As Amount
From htblticket
Where htblticket.spam <> 'True'
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date)) As TicketCount On TicketCount.Year =
DatePart(yyyy, htblticket.date) And TicketCount.Month = DatePart(mm,
htblticket.date)

Active Discussions

Lansweeper Modify "....less than 1GB free HD..." Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 8/15/2019 7:11:10 PM(UTC)
Lansweeper Individual asset compliance
by  ToeCutter  
Go to last post Go to first unread
Last post: 8/15/2019 11:40:57 AM(UTC)
Lansweeper Nvidia August Security Bulletin
by  Esben.D   Go to last post Go to first unread
Last post: 8/14/2019 9:00:17 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 8/14/2019 8:40:45 AM(UTC)
Lansweeper Help Desk report charted by Fiscal Year
by  Tom Londe   Go to last post Go to first unread
Last post: 8/12/2019 11:39:05 PM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  bnishan  
Go to last post Go to first unread
Last post: 8/12/2019 9:02:30 PM(UTC)
Report Center Top 5 Average RAM Usage
by  AlbertD   Go to last post Go to first unread
Last post: 8/12/2019 5:36:20 PM(UTC)
Lansweeper SWAPGS Report
by  Bginchereau  
Go to last post Go to first unread
Last post: 8/12/2019 2:25:22 PM(UTC)