Table: azure_network_watcher_flow_logs

This table shows data for Azure Network Watcher Flow Logs.

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

The primary key for this table is id.

Relations

This table depends 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.

Ensure that Network Security Group Flow Log retention period is ''greater than 90 days''

SELECT
  e'Ensure that Network Security Group Flow Log retention period is \'greater than 90 days\''
    AS title,
  subscription_id AS subscription_id,
  id AS resource_id,
  CASE
  WHEN (properties->'retentionPolicy'->>'days')::INT8 >= 90 THEN 'pass'
  ELSE 'fail'
  END
    AS status
FROM
  azure_network_watcher_flow_logs;