| title | sys.dm_server_audit_status (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_server_audit_status (Transact-SQL) | ||||
| author | sravanisaluru | ||||
| ms.author | srsaluru | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 03/09/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE sql-asdbmi]
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 column in the sys.audits catalog view. |
| name | sysname | Name of the audit. Same as the name column in the sys.server_audits catalog view. |
| status | smallint | Numeric status of the server audit: 0 = Not Started 1 = Started 2 = Runtime Fail 3 = Target Create Fail 4 = Shutting Down |
| status_desc | nvarchar(256) | String that shows the status of the server audit: - NOT_STARTED - STARTED - RUNTIME_FAIL - TARGET_CREATION_FAILED - SHUTTING_DOWN |
| 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 address column in the sys.dm_xe_sessions catalog view. |
| audit_file_path | nvarchar(256) | 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. |
Principals must have the VIEW SERVER SECURITY STATE permission.
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
- 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
- sys.dm_audit_actions (Transact-SQL)
- sys.dm_audit_class_type_map (Transact-SQL)
- Create a Server Audit and Server Audit Specification