Control: 2.3 Ensure that Microsoft Defender for Azure SQL Databases is set to 'On'

Description

Enabling Azure Defender threat detection for Azure SQL database servers, providing threat intelligence, anomaly detection, and behavior analytics in the Azure Security Center. It also allows for greater defense-in- depth, with threat detection provided by the Microsoft Security Response Center (MSRC).

Remediation

From Console

Perform the following action to check Azure Defender is set to On for Azure SQL database servers:

Go to Microsoft Defender for Cloud
Select Environment Settings blade
Click on the subscription name
Select the Defender plans blade
Review the chosen pricing tier. For the Azure SQL Databases resource type Plan should be set to On.

From Command Line

Command to enable Azure defender for Azure SQL database servers

az account get-access-token --query "{subscription:subscription,accessToken:accessToken}" --out tsv | xargs -L1 bash -c 'curl -X PUT -H "Authorization: Bearer $1" -H "Content-Type: application/json" https://management.azure.com/subscriptions/$0/providers/Microsoft.Security/pricings/SqlServers?api-version=2018-06-01 -d@"input.json"'

Where input.json contains the request body json data as mentioned below

{
  "id":"/subscriptions/<Your_Subscription_Id>/providers/Microsoft.Security/pricings/SqlServers",
  "name":"SqlServers",
  "type":"Microsoft.Security/pricings",
  "properties":{
    "pricingTier":"Standard"
  }
}

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.cis_v140_2_3

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.cis_v140_2_3 --share

SQL

This control uses a named query:

select
  sub_pricing.id as resource,
  case
    when pricing_tier = 'Standard' then 'ok'
    else 'alarm'
  end as status,
  case
    when pricing_tier = 'Standard' then 'Azure Defender on for SQL database servers.'
    else 'Azure Defender off for SQL database servers.'
  end as reason
  
  , sub.display_name as subscription
from
  azure_security_center_subscription_pricing sub_pricing
  right join azure_subscription sub on sub_pricing.subscription_id = sub.subscription_id
where
  name = 'SqlServers';