Query TicketMetrics in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the adapter.

SELECT * FROM TicketMetrics

SELECT * FROM TicketMetrics WHERE Id = '123'

SELECT * FROM TicketMetrics WHERE TicketId = '123' 

SELECT * FROM TIcketMetrics WHERE TicketId IN (SELECT Id FROM Tickets)

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	References	Description
Id [KEY]	Long		Automatically assigned.
TicketId	Integer	Tickets.Id	The ID of the associated ticket.
GroupStations	Integer		Number of groups this ticket passed through.
AssigneeStations	Integer		Number of assignees this ticket had.
Reopens	Integer		Total number of times the ticket was reopened.
Replies	Integer		Total number of times ticket was replied to.
AssigneeUpdatedAt	Datetime		When the assignee last updated the ticket.
RequesterUpdatedAt	Datetime		When the requester last updated the ticket.
StatusUpdatedAt	Datetime		When the status was last updated.
InitiallyAssignedAt	Datetime		When the ticket was initially assigned.
AssignedAt	Datetime		When the ticket was last assigned.
SolvedAt	Datetime		When the ticket was solved.
LatestCommentAddedAt	Datetime		When the latest comment was added.
FirstResolutionTimeCalendar	Int		Number of minutes to the first resolution time inside and out of business hours.
FirstResolutionTimeBusiness	Int		Number of minutes to the first resolution time inside and out of business hours.
ReplyTimeCalendar	Int		Number of minutes to the first reply inside and out of business hours.
ReplyTimeBusiness	Int		Number of minutes to the first reply inside and out of business hours.
FullResolutionTimeCalendar	Int		Number of minutes to the full resolution inside and out of business hours.
FullResolutionTimeBusiness	Int		Number of minutes to the full resolution inside and out of business hours.
AgentWaitTimeCalendar	Int		Number of minutes the agent spent waiting inside and out of business hours.
AgentWaitTimeBusiness	Int		Number of minutes the agent spent waiting inside and out of business hours.
RequesterWaitTimeCalendar	Int		Number of minutes the requester spent waiting inside and out of business hours.
RequesterWaitTimeBusiness	Int		Number of minutes the requester spent waiting inside and out of business hours.
CreatedAt	Datetime		When this record was created.
UpdatedAt	Datetime		When this record last got updated.
Url	String		The API url of this ticket metric.