TicketAudits

Returns ticket audits, including audit events, metadata, and channel source details.

Table-Specific Information

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

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		The unique Id automatically assigned when the audit is created.
TicketId	Integer	False	Tickets.Id	The Id of the associated ticket.
AuthorId	Long	False	Users.Id	The Id of the user who created the audit.
CreatedAt	Datetime	False		The date and time when the audit was created.
Metadata	String	False		The metadata for the audit, including custom and system data.
ViaChannel	String	False		The channel through which the audit was created.
ViaSource	String	False		The source details for the channel through which the audit was created.
Events	String	False		The array of events that occurred in this audit.