vw_packet_captures

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

Overview

Name	vw_packet_captures
Type	View
Id	azure.network.vw_packet_captures

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,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.target') as "target",
JSON_EXTRACT(properties, '$.scope') as "scope",
JSON_EXTRACT(properties, '$.targetType') as "target_type",
JSON_EXTRACT(properties, '$.bytesToCapturePerPacket') as "bytes_to_capture_per_packet",
JSON_EXTRACT(properties, '$.totalBytesPerSession') as "total_bytes_per_session",
JSON_EXTRACT(properties, '$.timeLimitInSeconds') as "time_limit_in_seconds",
JSON_EXTRACT(properties, '$.storageLocation') as "storage_location",
JSON_EXTRACT(properties, '$.filters') as "filters",
JSON_EXTRACT(properties, '$.continuousCapture') as "continuous_capture",
JSON_EXTRACT(properties, '$.captureSettings') as "capture_settings",
subscriptionId,
resourceGroupName,
networkWatcherName,
packetCaptureName
FROM azure.network.packet_captures
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
etag as etag,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.target') as "target",
json_extract_path_text(properties, '$.scope') as "scope",
json_extract_path_text(properties, '$.targetType') as "target_type",
json_extract_path_text(properties, '$.bytesToCapturePerPacket') as "bytes_to_capture_per_packet",
json_extract_path_text(properties, '$.totalBytesPerSession') as "total_bytes_per_session",
json_extract_path_text(properties, '$.timeLimitInSeconds') as "time_limit_in_seconds",
json_extract_path_text(properties, '$.storageLocation') as "storage_location",
json_extract_path_text(properties, '$.filters') as "filters",
json_extract_path_text(properties, '$.continuousCapture') as "continuous_capture",
json_extract_path_text(properties, '$.captureSettings') as "capture_settings",
subscriptionId,
resourceGroupName,
networkWatcherName,
packetCaptureName
FROM azure.network.packet_captures
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';