turbot/azure_compliance

Query: network_watcher_enabled

Usage

powerpipe query azure_compliance.query.network_watcher_enabled

SQL

select
loc.id resource,
case
when watcher.id is null then 'alarm'
else 'ok'
end as status,
case
when watcher.id is null then 'Network watcher not enabled in ' || loc.name || '.'
else 'Network watcher enabled in ' || loc.name || '.'
end as reason,
loc.name
, sub.display_name as subscription
from
azure_location loc
left join azure_network_watcher watcher on watcher.region = loc.name
join azure_subscription sub on sub.subscription_id = loc.subscription_id;

Controls

The query is being used by the following controls: