Skip to main content

vw_application_gateways

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

Overview​

Namevw_application_gateways
TypeView
Idazure.network.vw_application_gateways

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,
zones as zones,
identity as identity,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.sku') as "sku",
JSON_EXTRACT(properties, '$.sslPolicy') as "ssl_policy",
JSON_EXTRACT(properties, '$.operationalState') as "operational_state",
JSON_EXTRACT(properties, '$.gatewayIPConfigurations') as "gateway_ip_configurations",
JSON_EXTRACT(properties, '$.authenticationCertificates') as "authentication_certificates",
JSON_EXTRACT(properties, '$.trustedRootCertificates') as "trusted_root_certificates",
JSON_EXTRACT(properties, '$.trustedClientCertificates') as "trusted_client_certificates",
JSON_EXTRACT(properties, '$.sslCertificates') as "ssl_certificates",
JSON_EXTRACT(properties, '$.frontendIPConfigurations') as "frontend_ip_configurations",
JSON_EXTRACT(properties, '$.frontendPorts') as "frontend_ports",
JSON_EXTRACT(properties, '$.probes') as "probes",
JSON_EXTRACT(properties, '$.backendAddressPools') as "backend_address_pools",
JSON_EXTRACT(properties, '$.backendHttpSettingsCollection') as "backend_http_settings_collection",
JSON_EXTRACT(properties, '$.backendSettingsCollection') as "backend_settings_collection",
JSON_EXTRACT(properties, '$.httpListeners') as "http_listeners",
JSON_EXTRACT(properties, '$.listeners') as "listeners",
JSON_EXTRACT(properties, '$.sslProfiles') as "ssl_profiles",
JSON_EXTRACT(properties, '$.urlPathMaps') as "url_path_maps",
JSON_EXTRACT(properties, '$.requestRoutingRules') as "request_routing_rules",
JSON_EXTRACT(properties, '$.routingRules') as "routing_rules",
JSON_EXTRACT(properties, '$.rewriteRuleSets') as "rewrite_rule_sets",
JSON_EXTRACT(properties, '$.redirectConfigurations') as "redirect_configurations",
JSON_EXTRACT(properties, '$.webApplicationFirewallConfiguration') as "web_application_firewall_configuration",
JSON_EXTRACT(properties, '$.firewallPolicy') as "firewall_policy",
JSON_EXTRACT(properties, '$.enableHttp2') as "enable_http2",
JSON_EXTRACT(properties, '$.enableFips') as "enable_fips",
JSON_EXTRACT(properties, '$.autoscaleConfiguration') as "autoscale_configuration",
JSON_EXTRACT(properties, '$.privateLinkConfigurations') as "private_link_configurations",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.resourceGuid') as "resource_guid",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.customErrorConfigurations') as "custom_error_configurations",
JSON_EXTRACT(properties, '$.forceFirewallPolicyAssociation') as "force_firewall_policy_association",
JSON_EXTRACT(properties, '$.loadDistributionPolicies') as "load_distribution_policies",
JSON_EXTRACT(properties, '$.globalConfiguration') as "global_configuration",
JSON_EXTRACT(properties, '$.defaultPredefinedSslPolicy') as "default_predefined_ssl_policy",
subscriptionId,
resourceGroupName,
applicationGatewayName
FROM azure.network.application_gateways
WHERE subscriptionId = 'replace-me';