Table: azure_network_watchers

This table shows data for Azure Network Watchers.

https://learn.microsoft.com/en-us/rest/api/network-watcher/network-watchers/list-all?tabs=HTTP#networkwatcher (opens in a new tab)

The primary key for this table is id.

Relations

The following tables depend on azure_network_watchers:

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
subscription_idutf8
id (PK)utf8
locationutf8
propertiesjson
tagsjson
etagutf8
nameutf8
typeutf8

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Network Watcher should be enable

SELECT
  'Network Watcher should be enable' AS title,
  l.subscription_id,
  l.id,
  CASE
  WHEN anw._cq_id IS NULL THEN 'fail'
  ELSE 'pass'
  END
FROM
  azure_subscription_subscription_locations AS l
  LEFT JOIN azure_network_watchers AS anw ON l.name = anw.location;