Query: Ensure That Microsoft Defender for Databases is set to 'On'

Description

Turning on Microsoft Defender for Databases enables threat detection for the instances running your database software. This provides threat intelligence, anomaly detection, and behavior analytics in the Azure Microsoft Defender for Cloud. Instead of being enabled on services like Platform as a Service (PaaS), this implementation will run within your instances as Infrastructure as a Service (IaaS) on the Operating Systems hosting your databases.

Query

Tables used in this query:

• azure_security_center_subscription_pricing
• azure_subscription

Controls using this query:

• 2.1.3 Ensure That Microsoft Defender for Databases Is Set To 'On'
• 2.1.3 Ensure That Microsoft Defender for Databases Is Set To 'On'
• Ensure That Microsoft Defender for Databases is set to 'On'

SQL