sys.dm_server_audit_status (Transact-SQL)
Returns a row for each server audit indicating the current state of the audit. For more information, see SQL Server Audit (Database Engine).
Column name |
Data type |
Description |
|---|---|---|
audit_id |
int |
ID of the audit. Maps to the audit_id field in the sys.audits catalog view. |
name |
sysname |
Name of the audit. Same as the name field in the sys.server_audits catalog view. |
status |
tinyint |
Numeric status of the server audit: 0 – Started 1 – Failed |
status_desc |
nvarchar(60) |
String that shows the status of the server audit: - STARTED - FAILED |
status_time |
datetime2 |
Timestamp in UTC of the last status change for the audit. |
event_session_address |
varbinary(8) |
Address of the Extended Events session associated with the audit. Related to the sys.db_xe_sessions.address catalog view. |
audit_file_path |
nvarchar(260) |
Full path and file name of the audit file target that is currently being used. Only populated for file audits. |
audit_file_size |
bigint |
Approximate size of the audit file, in bytes. Only populated for file audits. |
Permissions
Principals must have VIEW SERVER STATE and SELECT permissions.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Reference
CREATE SERVER AUDIT (Transact-SQL)
ALTER SERVER AUDIT (Transact-SQL)
DROP SERVER AUDIT (Transact-SQL)
CREATE SERVER AUDIT SPECIFICATION (Transact-SQL)
ALTER SERVER AUDIT SPECIFICATION (Transact-SQL)
DROP SERVER AUDIT SPECIFICATION (Transact-SQL)
CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL)
ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL)
DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
ALTER AUTHORIZATION (Transact-SQL)
sys.fn_get_audit_file (Transact-SQL)
sys.server_audits (Transact-SQL)
sys.server_file_audits (Transact-SQL)
sys.server_audit_specifications (Transact-SQL)
sys.server_audit_specification_details (Transact-SQL)
sys.database_audit_specifications (Transact-SQL)
sys.database_audit_specification_details (Transact-SQL)
sys.dm_server_audit_status (Transact-SQL)
sys.dm_audit_actions (Transact-SQL)
sys.dm_audit_class_type_map (Transact-SQL)