Skip to main content

vw_custom_ip_prefixes

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

Overview​

Namevw_custom_ip_prefixes
TypeView
Idazure.network.vw_custom_ip_prefixes

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,
zones as zones,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.asn') as "asn",
JSON_EXTRACT(properties, '$.cidr') as "cidr",
JSON_EXTRACT(properties, '$.signedMessage') as "signed_message",
JSON_EXTRACT(properties, '$.authorizationMessage') as "authorization_message",
JSON_EXTRACT(properties, '$.customIpPrefixParent') as "custom_ip_prefix_parent",
JSON_EXTRACT(properties, '$.childCustomIpPrefixes') as "child_custom_ip_prefixes",
JSON_EXTRACT(properties, '$.commissionedState') as "commissioned_state",
JSON_EXTRACT(properties, '$.expressRouteAdvertise') as "express_route_advertise",
JSON_EXTRACT(properties, '$.geo') as "geo",
JSON_EXTRACT(properties, '$.noInternetAdvertise') as "no_internet_advertise",
JSON_EXTRACT(properties, '$.prefixType') as "prefix_type",
JSON_EXTRACT(properties, '$.publicIpPrefixes') as "public_ip_prefixes",
JSON_EXTRACT(properties, '$.resourceGuid') as "resource_guid",
JSON_EXTRACT(properties, '$.failedReason') as "failed_reason",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
customIpPrefixName
FROM azure.network.custom_ip_prefixes
WHERE subscriptionId = 'replace-me';