ODBC guide

List audit records (specific columns)


Same as listing all audit records but returns only the columns you need (e.g. Id, Timestamp, ActorUserId, ProjectName, ActionId, EventSummary). Use this to reduce payload size or to focus on specific fields for reporting or export.

SELECT Id, CorrelationId, ActivityId, ActorCUID, ActorUserId, AuthenticationMechanism,
Timestamp, ScopeType, ScopeDisplayName, ScopeId, IpAddress, UserAgent, ActionId, ProjectId, ProjectName,
ProcessTemplate, ProjectVisibility, StartTime, EndTime, BatchSize, EventSummary, Details, Area, Category,
CategoryDisplayName, ActorDisplayName, ActorImageUrl FROM AuditRecords