Overview

A customer may require a report that displays the activity their team has done on tickets on a specific day i.e. tickets that received a post on a specific day.

Solution

The KQL query below will generate a report of all tickets that have received a post today:

SELECT
'Tickets.Ticket ID', 'Tickets.Creation Date' , 'Tickets.Subject','Tickets.Type','Tickets.Status', 'Ticket Posts.Full Name' as 'Staff'
FROM
'Ticket Posts'
WHERE
'Ticket Posts.Creation Date' =Today() AND 'Ticket Posts.Creator' = 'Staff'

The 'Ticket Posts.Creation Date' filter can be customized accordingly to specify a given date.

Testing

Run the KQL query in Kayako Reports. You should see an output similar to the following: