Query audit logs in Zendesk.

Table Specific Information

Select

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

SELECT * FROM AuditLogs
SELECT * FROM AuditLogs WHERE Id = '13963723114908'

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.

Columns

Name	Type	References	Description
Id [KEY]	Long		The id automatically assigned upon creation.
ActorId	Long		Id of the user or system that initiated the change.
SourceId	Long		The id of the item being audited.
ActorName	String		Name of the user or system that initiated the change.
ActionLabel	String		Localized string of action field.
SourceType	String		Item type being audited.
SourceLabel	String		The name of the item being audited.
Action	String		Type of change made. Possible values are create, destroy, exported, login, and update.
ChangeDescription	String		The description of the change that occurred.
IpAddress	String		The IP address of the user doing the audit.
CreatedAt	Datetime		The time the audit got created.
Url	String		The URL to access the audit log.