vw_flow_logs

Creates, updates, deletes, gets or lists a vw_flow_logs resource.

Overview

Name	vw_flow_logs
Type	View
Id	azure.network.vw_flow_logs

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
etag as etag,
identity as identity,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.targetResourceId') as "target_resource_id",
JSON_EXTRACT(properties, '$.targetResourceGuid') as "target_resource_guid",
JSON_EXTRACT(properties, '$.storageId') as "storage_id",
JSON_EXTRACT(properties, '$.enabledFilteringCriteria') as "enabled_filtering_criteria",
JSON_EXTRACT(properties, '$.enabled') as "enabled",
JSON_EXTRACT(properties, '$.retentionPolicy') as "retention_policy",
JSON_EXTRACT(properties, '$.format') as "format",
JSON_EXTRACT(properties, '$.flowAnalyticsConfiguration') as "flow_analytics_configuration",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
networkWatcherName,
flowLogName
FROM azure.network.flow_logs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
etag as etag,
identity as identity,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.targetResourceId') as "target_resource_id",
json_extract_path_text(properties, '$.targetResourceGuid') as "target_resource_guid",
json_extract_path_text(properties, '$.storageId') as "storage_id",
json_extract_path_text(properties, '$.enabledFilteringCriteria') as "enabled_filtering_criteria",
json_extract_path_text(properties, '$.enabled') as "enabled",
json_extract_path_text(properties, '$.retentionPolicy') as "retention_policy",
json_extract_path_text(properties, '$.format') as "format",
json_extract_path_text(properties, '$.flowAnalyticsConfiguration') as "flow_analytics_configuration",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
networkWatcherName,
flowLogName
FROM azure.network.flow_logs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';