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 connector.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. |