TicketMetricEvents
Queries 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'
To get the TicketIds of deleted tickets run this query:
GETDELETED FROM TicketMetricEvents
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 when the record is created. | |
| TicketId | Integer | False |
Tickets.Id |
The Id of the associated ticket. |
| Metric | String | False |
One of the following: agent_work_time, pausable_update_time, periodic_update_time, reply_time, requester_wait_time, or resolution_time. | |
| InstanceId | Long | False |
The instance of the metric associated with the event. | |
| Type | String | False |
When this locale last got updated. | |
| Time | Datetime | False |
The time the event occurred. | |
| Sla | String | False |
Available if type is apply_sla. The SLA policy and target being enforced on the ticket and the metric in question, if any. | |
| Status | String | False |
Available if type is update_status. Minutes since the metric has been open. See status. | |
| Deleted | Boolean | False |
Available if type is breach. In general, you can ignore any breach event when deleted is true. |