What Is the KQL Query That List Total Count of Tickets Handled by Agents?

Overview

You might want to know the KQL query that will list or generate a report of the total count of tickets handled by agents on a particular given period.

Information

Reports in Kayako Classic lets you access the huge amount of data in your helpdesk and turn that data into useful information.

Kayako Classic allows you to create your own report using Kayako Query Language (KQL). KQL is the syntax used to define a report. KQL is used to specify the data you want to include in your reports and how the data should be displayed.

A sample KQL syntax that would allow you to achieve this need is the following:

SELECT count(distinct 'Tickets.Ticket ID') , 'Tickets.Subject','Tickets.Type','Tickets.Status',
'Tickets.Owner' FROM 'Ticket Posts' WHERE 'Tickets.Creation Date' =LastWeek() AND 
'Ticket Posts.Creator' = 'Staff' MULTIGROUP BY 'Ticket Posts.Full Name'

Use this syntax to build your report. You may customize it further per your need. To learn more about building reports in Kayako, visit the Introduction to Building and Running Reports article.