Skip to main content

vw_vpn_server_configurations

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

Overview​

Namevw_vpn_server_configurations
TypeView
Idazure.network.vw_vpn_server_configurations

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,
systemData as system_data,
JSON_EXTRACT(properties, '$.name') as "name",
JSON_EXTRACT(properties, '$.vpnProtocols') as "vpn_protocols",
JSON_EXTRACT(properties, '$.vpnAuthenticationTypes') as "vpn_authentication_types",
JSON_EXTRACT(properties, '$.vpnClientRootCertificates') as "vpn_client_root_certificates",
JSON_EXTRACT(properties, '$.vpnClientRevokedCertificates') as "vpn_client_revoked_certificates",
JSON_EXTRACT(properties, '$.radiusServerRootCertificates') as "radius_server_root_certificates",
JSON_EXTRACT(properties, '$.radiusClientRootCertificates') as "radius_client_root_certificates",
JSON_EXTRACT(properties, '$.vpnClientIpsecPolicies') as "vpn_client_ipsec_policies",
JSON_EXTRACT(properties, '$.radiusServerAddress') as "radius_server_address",
JSON_EXTRACT(properties, '$.radiusServerSecret') as "radius_server_secret",
JSON_EXTRACT(properties, '$.radiusServers') as "radius_servers",
JSON_EXTRACT(properties, '$.aadAuthenticationParameters') as "aad_authentication_parameters",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.p2SVpnGateways') as "p2_s_vpn_gateways",
JSON_EXTRACT(properties, '$.configurationPolicyGroups') as "configuration_policy_groups",
JSON_EXTRACT(properties, '$.etag') as "etag",
subscriptionId,
resourceGroupName,
vpnServerConfigurationName
FROM azure.network.vpn_server_configurations
WHERE subscriptionId = 'replace-me';