Query: Auditing on SQL server should be enabled

Description

Auditing on your SQL Server should be enabled to track database activities across all databases on the server and save them in an audit log.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• 4.1.1 Ensure that 'Auditing' is set to 'On'
• 4.1.1 Ensure that 'Auditing' is set to 'On'
• 4.1.1 Ensure that 'Auditing' is set to 'On'
• 4.1.1 Ensure that 'Auditing' is set to 'On'
• 4.1.1 Ensure that 'Auditing' is set to 'On'
• 5.1.1 Ensure that 'Auditing' is set to 'On'
• Auditing on SQL server should be enabled

SQL