Query: network_watcher_enabled

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;