TicketAudits

Query TicketAudits in Zendesk.

Table Specific Information

The following queries are processed server side while other filters are processed client side within the add-in.

SELECT * FROM TicketAudits WHERE TicketId = '123'

SELECT * FROM TicketAudits WHERE TicketId = '123' AND Id = '456'

To get the TicketIds of deleted tickets, run this query:

GETDELETED FROM TicketAudits


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Automatically assigned when creating audits.
TicketId	Integer	False	Tickets.Id	The ID of the associated ticket.
AuthorId	Long	False	Users.Id	The user who created the audit.
CreatedAt	Datetime	False		The time the audit was created.
Metadata	String	False		Metadata for the audit, custom and system data.
ViaChannel	String	False		This object explains how this audit was created. This does not update on every request.
ViaSource	String	False		This object explains how this audit was created. This does not update on every request.
Events	String	False		The Array of Events that happened in this Audit.