turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_compute_availability_setazure_compute_diskazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_diagnostic_settingazure_express_route_circuitazure_firewallazure_key_vaultazure_key_vault_keyazure_key_vault_secretazure_kubernetes_clusterazure_locationazure_log_alertazure_log_profileazure_management_lockazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_resource_groupazure_role_assignmentazure_role_definitionazure_route_tableazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_settingazure_security_center_subscription_pricingazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_virtual_network_gateway

A virtual network gateway is used to establish secure, cross-premises connectivity.

Examples

Basic info

select
name,
id,
enable_bgp,
region,
resource_group
from
azure_virtual_network_gateway;

List network gateways with no connections

select
name,
id,
enable_bgp,
region,
resource_group
from
azure_virtual_network_gateway
where
gateway_connection is null;

.inspect azure_virtual_network_gateway

Azure Virtual Network Gateway

NameTypeDescription
active_activebooleanIndicates whether virtual network gateway configured with active-active mode, or not. If true, each Azure gateway instance will have a unique public IP address, and each will establish an IPsec/IKE S2S VPN tunnel to your on-premises VPN device specified in your local network gateway and connection.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
bgp_settingsjsonbVirtual network gateway's BGP speaker settings.
custom_routes_address_prefixesjsonbA list of address blocks reserved for this virtual network in CIDR notation.
enable_bgpbooleanIndicates whether BGP is enabled for this virtual network gateway, or not.
enable_dns_forwardingbooleanIndicates whether DNS forwarding is enabled, or not.
enable_private_ip_addressbooleanIndicates whether private IP needs to be enabled on this gateway for connections or not.
etagtextAn unique read-only string that changes whenever the resource is updated.
gateway_connectionsjsonbA list of virtual network gateway connection resources that exists in a resource group.
gateway_default_sitetextThe reference to the LocalNetworkGateway resource, which represents local network site having default routes. Assign Null value in case of removing existing default site setting.
gateway_typetextThe type of this virtual network gateway. Possible values include: 'Vpn', 'ExpressRoute'.
idtextContains ID to identify a virtual network gateway uniquely.
inbound_dns_forwarding_endpointtextThe IP address allocated by the gateway to which dns requests can be sent.
ip_configurationsjsonbIP configurations for virtual network gateway.
nametextThe friendly name that identifies the virtual network gateway.
provisioning_statetextThe provisioning state of the virtual network gateway resource.
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
resource_guidtextThe resource GUID property of the virtual network gateway resource.
sku_capacitybigintGateway SKU capacity.
sku_nametextGateway SKU name.
sku_tiertextGateway SKU tier.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextType of the resource.
vpn_client_configurationjsonbThe reference to the VpnClientConfiguration resource which represents the P2S VpnClient configurations.
vpn_gateway_generationtextThe generation for this virtual network gateway. Must be None if gatewayType is not VPN. Valid values are: 'None', 'Generation1', 'Generation2'.
vpn_typetextThe type of this virtual network gateway. Valid values are: 'PolicyBased', 'RouteBased'.