TicketMetrics
Query TicketMetrics in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM TicketMetrics WHERE Id = '123' SELECT * FROM TicketMetrics WHERE TicketId = '123' SELECT * FROM TIcketMetrics WHERE TicketId IN (SELECT Id FROM Tickets)
To get the TicketIds of deleted tickets run this query:
GETDELETED FROM TicketMetrics
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 | ReadOnly | References | Description |
Id [KEY] | Long | False |
Automatically assigned. | |
TicketId [KEY] | Integer | False |
Tickets.Id |
The ID of the associated ticket. |
GroupStations | Integer | False |
Number of groups this ticket passed through. | |
AssigneeStations | Integer | False |
Number of assignees this ticket had. | |
Reopens | Integer | False |
Total number of times the ticket was reopened. | |
Replies | Integer | False |
Total number of times ticket was replied to. | |
AssigneeUpdatedAt | Datetime | False |
When the assignee last updated the ticket. | |
RequesterUpdatedAt | Datetime | False |
When the requester last updated the ticket. | |
StatusUpdatedAt | Datetime | False |
When the status was last updated. | |
InitiallyAssignedAt | Datetime | False |
When the ticket was initially assigned. | |
AssignedAt | Datetime | False |
When the ticket was last assigned. | |
SolvedAt | Datetime | False |
When the ticket was solved. | |
LatestCommentAddedAt | Datetime | False |
When the latest comment was added. | |
FirstResolutionTimeCalendar | Int | False |
Number of minutes to the first resolution time inside and out of business hours. | |
FirstResolutionTimeBusiness | Int | False |
Number of minutes to the first resolution time inside and out of business hours. | |
ReplyTimeCalendar | Int | False |
Number of minutes to the first reply inside and out of business hours. | |
ReplyTimeBusiness | Int | False |
Number of minutes to the first reply inside and out of business hours. | |
FullResolutionTimeCalendar | Int | False |
Number of minutes to the full resolution inside and out of business hours. | |
FullResolutionTimeBusiness | Int | False |
Number of minutes to the full resolution inside and out of business hours. | |
AgentWaitTimeCalendar | Int | False |
Number of minutes the agent spent waiting inside and out of business hours. | |
AgentWaitTimeBusiness | Int | False |
Number of minutes the agent spent waiting inside and out of business hours. | |
RequesterWaitTimeCalendar | Int | False |
Number of minutes the requester spent waiting inside and out of business hours. | |
RequesterWaitTimeBusiness | Int | False |
Number of minutes the requester spent waiting inside and out of business hours. | |
CreatedAt | Datetime | False |
When this record was created. | |
UpdatedAt | Datetime | False |
When this record last got updated. | |
Url | String | False |
The API url of this ticket metric. |