TicketMetricEvents

Provides ticket metric events that track timing milestones and SLA activity for tickets.

Table-Specific Information

To query ticket metric events starting from a given time:

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		The Id automatically assigned when the record is created.
TicketId	Integer	False	Tickets.Id	The Id of the associated ticket.
Metric	String	False		The metric being tracked. Possible values: 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		The type of metric event. Possible values: activate, pause, fulfill, apply_sla, breach, update_status, or unknown.
Time	Datetime	False		The time the event occurred.
Sla	String	False		The SLA policy and target being enforced on the ticket and the metric in question, if any. Available if the type is apply_sla.
Status	String	False		The number of minutes the metric has been open. Available if the type is update_status.
Deleted	Boolean	False		Indicates whether the breach event has been deleted. Available if the type is breach. Breach events where this value is true can generally be ignored.