Skip to main content

Snippet usage by Agent

in Reports using Ticket Logs
Authors list
Published: May 22, 2018|Last updated: Mar 3, 2025

Requirement: create a report to show frequency of usage of snippets by each agent, with a pull-down to select the time period.

Title: Snippets used ${date} split by agent

SELECT v2_snippet_use_log.snippet.title, DPQL_COUNT() AS 'Uses' FROM v2_snippet_use_log WHERE v2_snippet_use_log.snippet.id <> NULL AND v2_snippet_use_log.date_created = ${date} SPLIT BY v2_snippet_use_log.person GROUP BY v2_snippet_use_log.snippet.id ORDER BY DPQL_COUNT() DESC)
copy

Variable

image.png

HelpfulUnhelpful
next pageTicket Backlog with a Custom Timeframe
previous pageCount times Tickets were Moved into a Department

Please log in or register to submit a comment.