vw_plans_vnet_from_server_farms

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

Overview

Name	vw_plans_vnet_from_server_farms
Type	View
Id	azure.app_service.vw_plans_vnet_from_server_farms

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,
vnetName
FROM azure.app_service.plans_vnet_from_server_farms
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND name = '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,
vnetName
FROM azure.app_service.plans_vnet_from_server_farms
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND name = 'replace-me' AND vnetName = 'replace-me';