TicketMetricEvents

Queries TicketMetricEvents in Zendesk.

Table Specific Information

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


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.