Query: Azure Defender for SQL should be enabled for unprotected SQL Managed Instances

Description

Audit each SQL Managed Instance without advanced data security.

Query

Tables used in this query:

• azure_security_center_subscription_pricing
• azure_subscription

Controls using this query:

• 2.1.4 Ensure That Microsoft Defender for SQL Servers on Machines Is Set To 'On'
• 2.1.5 Ensure That Microsoft Defender for SQL Servers on Machines Is Set To 'On'
• 2.1.5 Ensure That Microsoft Defender for SQL Servers on Machines Is Set To 'On'
• 2.4 Ensure that Azure Defender is set to On for SQL servers on machines
• 2.4 Ensure that Microsoft Defender for SQL servers on machines is set to 'On'
• 3.1.7.4 Ensure That Microsoft Defender for SQL Servers on Machines Is Set To 'On'
• Azure Defender for SQL should be enabled for unprotected SQL Managed Instances

SQL