Recent History - Operational Auditing

Auditing for operational purposes, based on historical data from Recently Executed Statements

Columns

Name Description
Inst ID Instance ID; 0 = non-CE
SPID Session process ID
SQL Text SQL text preview
Start Time Start time of statement
Elapsed Time Elapsed time
Rows Affected Number of rows affected
Login User login name
Start Database Name of the database where the batch started
Error Status Error code, if an error occurred
Batch ID Batch ID
End Time End time of statement
KPID Kernel process ID

Entity Requirements

Attributes: MDA
Minimum database version: 15.0.3