I would like to find out how many tickets a specific user created each month

[SJSafeware]

Hello I have bee tasked with finding out how many tickets two users created out of the total tickets created for the last two months. 

I figure there must be a way to create a report that can list the number of tickets created by user per month? And then I can compare that to the total number of tickets created each month. 

[SJSafeware]

I was under the impression agent would be our IT team. I want users who are submitting tickets and the count of tickets they are submitting. Would agent work for that? How would I specify the user? 

[Katgroup]

There should be a few "Count of tickets per agent ..." reports built-in. Try this one:

• Helpdesk: Count of tickets per agent, month and type

[SJSafeware]

I was under the impression agent would be our IT team. I want users who are submitting tickets and the count of tickets they are submitting. Would agent work for that? How would I specify the user? 

[Katgroup]

Apologies, I had misread that you want users, not agents.

I threw this together quickly, let me know if it works.

Select Top 1000000 htblusers.name,
  Format(htblticket.date, 'yyyy-MM') As Month,
  Count(htblticket.ticketid) As Tickets
From htblusers
  Left Join htblticket On htblticket.fromuserid = htblusers.userid
Where htblticket.ticketid Is Not Null
Group By htblusers.name,
  Format(htblticket.date, 'yyyy-MM')
Order By Month Desc,
  Tickets Desc,
  htblusers.name

Personally I would take the per-month logic out of the report and track it separately.