Control: 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.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.sql_server_auditing_on
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.sql_server_auditing_on --share
SQL
This control uses a named query:
sql_server_auditing_on