vw_connection_monitors

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

Overview

Name	vw_connection_monitors
Type	View
Id	azure.network.vw_connection_monitors

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
location as location,
etag as etag,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.monitoringStatus') as "monitoring_status",
JSON_EXTRACT(properties, '$.connectionMonitorType') as "connection_monitor_type",
JSON_EXTRACT(properties, '$.source') as "source",
JSON_EXTRACT(properties, '$.destination') as "destination",
JSON_EXTRACT(properties, '$.autoStart') as "auto_start",
JSON_EXTRACT(properties, '$.monitoringIntervalInSeconds') as "monitoring_interval_in_seconds",
JSON_EXTRACT(properties, '$.endpoints') as "endpoints",
JSON_EXTRACT(properties, '$.testConfigurations') as "test_configurations",
JSON_EXTRACT(properties, '$.testGroups') as "test_groups",
JSON_EXTRACT(properties, '$.outputs') as "outputs",
JSON_EXTRACT(properties, '$.notes') as "notes",
subscriptionId,
resourceGroupName,
networkWatcherName,
connectionMonitorName
FROM azure.network.connection_monitors
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
etag as etag,
type as type,
tags as tags,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.startTime') as "start_time",
json_extract_path_text(properties, '$.monitoringStatus') as "monitoring_status",
json_extract_path_text(properties, '$.connectionMonitorType') as "connection_monitor_type",
json_extract_path_text(properties, '$.source') as "source",
json_extract_path_text(properties, '$.destination') as "destination",
json_extract_path_text(properties, '$.autoStart') as "auto_start",
json_extract_path_text(properties, '$.monitoringIntervalInSeconds') as "monitoring_interval_in_seconds",
json_extract_path_text(properties, '$.endpoints') as "endpoints",
json_extract_path_text(properties, '$.testConfigurations') as "test_configurations",
json_extract_path_text(properties, '$.testGroups') as "test_groups",
json_extract_path_text(properties, '$.outputs') as "outputs",
json_extract_path_text(properties, '$.notes') as "notes",
subscriptionId,
resourceGroupName,
networkWatcherName,
connectionMonitorName
FROM azure.network.connection_monitors
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkWatcherName = 'replace-me';