vw_vnet_connection_slots

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

Overview

Name	vw_vnet_connection_slots
Type	View
Id	azure.app_service.vw_vnet_connection_slots

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
kind as kind,
type as type,
JSON_EXTRACT(properties, '$.vnetResourceId') as "vnet_resource_id",
JSON_EXTRACT(properties, '$.certThumbprint') as "cert_thumbprint",
JSON_EXTRACT(properties, '$.certBlob') as "cert_blob",
JSON_EXTRACT(properties, '$.routes') as "routes",
JSON_EXTRACT(properties, '$.resyncRequired') as "resync_required",
JSON_EXTRACT(properties, '$.dnsServers') as "dns_servers",
JSON_EXTRACT(properties, '$.isSwift') as "is_swift",
subscriptionId,
resourceGroupName,
name,
slot,
vnetName
FROM azure.app_service.vnet_connection_slots
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND name = 'replace-me' AND slot = 'replace-me' AND vnetName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
kind as kind,
type as type,
json_extract_path_text(properties, '$.vnetResourceId') as "vnet_resource_id",
json_extract_path_text(properties, '$.certThumbprint') as "cert_thumbprint",
json_extract_path_text(properties, '$.certBlob') as "cert_blob",
json_extract_path_text(properties, '$.routes') as "routes",
json_extract_path_text(properties, '$.resyncRequired') as "resync_required",
json_extract_path_text(properties, '$.dnsServers') as "dns_servers",
json_extract_path_text(properties, '$.isSwift') as "is_swift",
subscriptionId,
resourceGroupName,
name,
slot,
vnetName
FROM azure.app_service.vnet_connection_slots
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND name = 'replace-me' AND slot = 'replace-me' AND vnetName = 'replace-me';