Skip to main content

vw_subnets

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

Overview​

Namevw_subnets
TypeView
Idazure.network.vw_subnets

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
etag as etag,
type as type,
JSON_EXTRACT(properties, '$.addressPrefix') as "address_prefix",
JSON_EXTRACT(properties, '$.addressPrefixes') as "address_prefixes",
JSON_EXTRACT(properties, '$.networkSecurityGroup') as "network_security_group",
JSON_EXTRACT(properties, '$.routeTable') as "route_table",
JSON_EXTRACT(properties, '$.natGateway') as "nat_gateway",
JSON_EXTRACT(properties, '$.serviceEndpoints') as "service_endpoints",
JSON_EXTRACT(properties, '$.serviceEndpointPolicies') as "service_endpoint_policies",
JSON_EXTRACT(properties, '$.privateEndpoints') as "private_endpoints",
JSON_EXTRACT(properties, '$.ipConfigurations') as "ip_configurations",
JSON_EXTRACT(properties, '$.ipConfigurationProfiles') as "ip_configuration_profiles",
JSON_EXTRACT(properties, '$.ipAllocations') as "ip_allocations",
JSON_EXTRACT(properties, '$.resourceNavigationLinks') as "resource_navigation_links",
JSON_EXTRACT(properties, '$.serviceAssociationLinks') as "service_association_links",
JSON_EXTRACT(properties, '$.delegations') as "delegations",
JSON_EXTRACT(properties, '$.purpose') as "purpose",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.privateEndpointNetworkPolicies') as "private_endpoint_network_policies",
JSON_EXTRACT(properties, '$.privateLinkServiceNetworkPolicies') as "private_link_service_network_policies",
JSON_EXTRACT(properties, '$.applicationGatewayIPConfigurations') as "application_gateway_ip_configurations",
JSON_EXTRACT(properties, '$.sharingScope') as "sharing_scope",
JSON_EXTRACT(properties, '$.defaultOutboundAccess') as "default_outbound_access",
subscriptionId,
resourceGroupName,
virtualNetworkName,
subnetName
FROM azure.network.subnets
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND virtualNetworkName = 'replace-me';