Control: Azure Defender for SQL should be enabled for unprotected SQL Managed Instances
Description
Audit each SQL Managed Instance without advanced data security. Turning on Azure Defender enables threat detection for SQL Managed Instance, providing threat intelligence, anomaly detection, and behavior analytics in the Azure Security Center
Usage
Run the control in your terminal:
powerpipe control run terraform_azure_compliance.control.securitycenter_azure_defender_on_for_sqlservervmSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run terraform_azure_compliance.control.securitycenter_azure_defender_on_for_sqlservervm --shareSQL
This control uses a named query:
securitycenter_azure_defender_on_for_sqlservervm