TicketMetricEvents
Query TicketMetricEvents in Zendesk.
Table Specific Information
Select
To query all ticket metric events, use the following query:
SELECT * FROM TicketMetricEvents
To query ticket metric events, starting from a given time, use the following example:
SELECT * FROM TicketMetricEvents WHERE StartTime = '2017-02-05'
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 when the record is created. | |
| TicketId | Integer |
Tickets.Id | Id of the associated ticket. |
| Metric | String | One of the following: agent_work_time, pausable_update_time, periodic_update_time, reply_time, requester_wait_time, or resolution_time. | |
| InstanceId | Long | The instance of the metric associated with the event. | |
| Type | String | When this locale last got updated. | |
| Time | Datetime | The time the event occurred. | |
| Sla | String | Available if type is apply_sla. The SLA policy and target being enforced on the ticket and metric in question, if any. | |
| Status | String | Available if type is update_status. Minutes since the metric has been open. See status. | |
| Deleted | Boolean | Available if type is breach. In general, you can ignore any breach event when deleted is true. |