Control: Ensure that Advanced Threat Protection (ATP) on a SQL server is set to 'Enabled'
Description
Enable 'Azure Defender for SQL' on critical SQL Servers. It is recommended to enable Azure Defender for SQL on critical SQL Servers. Azure Defender for SQL is a unified package for advanced security capabilities
Usage
Run the control in your terminal:
powerpipe control run terraform_azure_compliance.control.sql_server_atp_enabled
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_azure_compliance.control.sql_server_atp_enabled --share
SQL
This control uses a named query:
sql_server_atp_enabled