Skip to main content

Tickets Closed with One Response - DPQL Reports - Deskpro Support

If you would like to report which tickets have been closed with one message from the agent you can use the DPQL below:

SELECT, tickets_messages.ticket.subject
FROM tickets_messages
WHERE tickets_messages.ticket.count_agent_replies = '1' AND tickets_messages.person.is_agent = 1 AND tickets_messages.date_created = %LAST_WEEK% AND tickets_messages.is_agent_note = 0
SPLIT BY tickets_messages.person
ORDER BY tickets_messages.date_created 

This will split the results out by each agent and show details for each ticket that was quickly resolved by the agent. 

Add a comment

Please log in or register to submit a comment.

Need a password reminder?