Query TicketMetricEvents in Zendesk.
Table Specific Information
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.
|Id [KEY]||Long||Automatically assigned when the record is created.|
|TicketId||Integer||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.|