SV-276252r1149665_rule
V-276252
SRG-APP-000357-DB-000316
MSQL-00-010900
CAT II
10
Review the Azure SQL Managed Instance Audit file configuration information:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql
Run the following query:
SELECT name AS 'Audit Name',
status_desc AS 'Audit Status',
audit_file_path AS 'Current Audit File'
FROM sys.dm_server_audit_status
WHERE name NOT IN ('admin_audit','SqlDbThreatDetection_ServerAudit')
If no records are returned or the audit_file_path is NULL, this is a finding.
V-276252
False
MSQL-00-010900
Run the following query:
SELECT name AS 'Audit Name',
status_desc AS 'Audit Status',
audit_file_path AS 'Current Audit File'
FROM sys.dm_server_audit_status
WHERE name NOT IN ('admin_audit','SqlDbThreatDetection_ServerAudit')
If no records are returned or the audit_file_path is NULL, this is a finding.
M
5711