Total Closed Tickets By Agent over last 30 days/month

[aaronatkinson]

Hi,

Sorry I did look to see if something like this already existed, but could not find any, possibly due to search parameters.

Does this already exist or is it easy enough to create?

Kind Regards,

Edit:

e.g.

Tom 25
Fred 49
Harry 17
John 31

[Esben_D]

Ah, well. In that case, you can modify the built-in report "Helpdesk: Count of tickets per agent, this month"

If you add the table htblticketstates and add a criteria that statename = 'Closed' it should give you what you want.

[aaronatkinson]

Ah sorry, I forgot to include, rather than a bulk list of closed tickets, a list of each agent and how many they have closed in the last 30 days.

e.g.

Tom 25
Fred 49
Harry 17
John 31

[Esben_D]

I think a slight modification of the built-in report "Helpdesk: Tickets closed in last 7 days" will do.

Near the end of the query, you can change:

Having Max(htblhistory.date) > GetDate() - 7 to Having Max(htblhistory.date) > GetDate() - 30.

If you want, you can also add an additional criteria and enter the name of the agent you want to see all the closed tickets off.