Skip to main content

vw_virtual_networks

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

Overview​

Namevw_virtual_networks
TypeView
Idazure.network.vw_virtual_networks

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
extendedLocation as extended_location,
etag as etag,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.addressSpace') as "address_space",
JSON_EXTRACT(properties, '$.dhcpOptions') as "dhcp_options",
JSON_EXTRACT(properties, '$.flowTimeoutInMinutes') as "flow_timeout_in_minutes",
JSON_EXTRACT(properties, '$.subnets') as "subnets",
JSON_EXTRACT(properties, '$.virtualNetworkPeerings') as "virtual_network_peerings",
JSON_EXTRACT(properties, '$.resourceGuid') as "resource_guid",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.enableDdosProtection') as "enable_ddos_protection",
JSON_EXTRACT(properties, '$.enableVmProtection') as "enable_vm_protection",
JSON_EXTRACT(properties, '$.ddosProtectionPlan') as "ddos_protection_plan",
JSON_EXTRACT(properties, '$.bgpCommunities') as "bgp_communities",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.ipAllocations') as "ip_allocations",
JSON_EXTRACT(properties, '$.flowLogs') as "flow_logs",
JSON_EXTRACT(properties, '$.privateEndpointVNetPolicies') as "private_endpoint_v_net_policies",
subscriptionId,
resourceGroupName,
virtualNetworkName
FROM azure.network.virtual_networks
WHERE subscriptionId = 'replace-me';