turbot/azure_compliance

Query: securitycenter_azure_defender_on_for_sqlservervm

Usage

powerpipe query azure_compliance.query.securitycenter_azure_defender_on_for_sqlservervm

SQL

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 servers on machines.'
else 'Azure Defender off for SQL servers on machines.'
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 = 'SqlServerVirtualMachines';

Controls

The query is being used by the following controls: