turbot/alicloud

GitHub
steampipe plugin install alicloudsteampipe plugin install alicloud
alicloud_accountalicloud_action_trailalicloud_cas_certificatealicloud_cms_monitor_hostalicloud_cs_kubernetes_clusteralicloud_cs_kubernetes_cluster_nodealicloud_ecs_auto_provisioning_groupalicloud_ecs_autoscaling_groupalicloud_ecs_diskalicloud_ecs_disk_metric_read_iopsalicloud_ecs_disk_metric_read_iops_dailyalicloud_ecs_disk_metric_read_iops_hourlyalicloud_ecs_disk_metric_write_iopsalicloud_ecs_disk_metric_write_iops_dailyalicloud_ecs_disk_metric_write_iops_hourlyalicloud_ecs_imagealicloud_ecs_instancealicloud_ecs_instance_metric_cpu_utilization_dailyalicloud_ecs_instance_metric_cpu_utilization_hourlyalicloud_ecs_key_pairalicloud_ecs_launch_templatealicloud_ecs_network_interfacealicloud_ecs_regionalicloud_ecs_security_groupalicloud_ecs_snapshotalicloud_ecs_zonealicloud_kms_keyalicloud_kms_secretalicloud_oss_bucketalicloud_ram_access_keyalicloud_ram_credential_reportalicloud_ram_groupalicloud_ram_password_policyalicloud_ram_policyalicloud_ram_rolealicloud_ram_security_preferencealicloud_ram_useralicloud_rds_backupalicloud_rds_databasealicloud_rds_instancealicloud_rds_instance_metric_connectionsalicloud_rds_instance_metric_connections_dailyalicloud_rds_instance_metric_cpu_utilizationalicloud_rds_instance_metric_cpu_utilization_dailyalicloud_rds_instance_metric_cpu_utilization_hourlyalicloud_security_center_field_statisticsalicloud_security_center_versionalicloud_slb_load_balanceralicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_flow_logalicloud_vpc_nat_gatewayalicloud_vpc_network_aclalicloud_vpc_route_entryalicloud_vpc_route_tablealicloud_vpc_ssl_vpn_client_certalicloud_vpc_ssl_vpn_serveralicloud_vpc_vpn_connectionalicloud_vpc_vpn_customer_gatewayalicloud_vpc_vpn_gatewayalicloud_vpc_vswitch

Table: alicloud_vpc_vpn_gateway

VPN Gateway is an Internet-based service that establishes a connection between a VPC and on-premise data center.

Examples

Basic info

select
name,
vpn_gateway_id,
status,
description,
internet_ip,
billing_method,
business_status,
region
from
alicloud_vpc_vpn_gateway;

Get the VPC and VSwitch info of VPN gateway

select
name,
vpn_gateway_id,
vpc_id vswitch_id
from
alicloud_vpc_vpn_gateway;

Get the vpn gateways where SSL VPN is enabled

select
name,
vpn_gateway_id,
ssl_vpn,
ssl_max_connections
from
alicloud_vpc_vpn_gateway
where
ssl_vpn = 'enable';

VPN gateway count by VPC ID

select
vpc_id,
count(vpn_gateway_id) as vpn_gateway_count
from
alicloud_vpc_vpn_gateway
group by
vpc_id;

List of VPN gateways without application tag key

select
vpn_gateway_id,
tags
from
alicloud_vpc_vpn_gateway
where
tags -> 'application' is null;

List inactive VPN gateways

select
vpn_gateway_id,
status,
create_time,
jsonb_pretty(tags)
from
alicloud_vpc_vpn_gateway
where
status <> 'active';

.inspect alicloud_vpc_vpn_gateway

Alicloud VPC VPN Gateway.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe Alicloud Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
auto_propagatebooleanIndicates whether auto propagate is enabled, or not.
billing_methodtextThe billing method of the VPN gateway.
business_statustextThe business state of the VPN gateway.
create_timetimestamp with time zoneThe time when the VPN gateway was created.
descriptiontextThe description of the VPN gateway.
enable_bgpbooleanIndicates whether bgp is enabled.
end_timetimestamp with time zoneThe creation time of the VPC.
internet_ipinetThe public IP address of the VPN gateway.
ipsec_vpntextIndicates whether the IPsec-VPN feature is enabled.
nametextThe name of the VPN gateway.
regiontextThe Alicloud region in which the resource is located.
reservation_datajsonbA set of reservation details.
spectextThe maximum bandwidth of the VPN gateway.
ssl_max_connectionsbigintThe maximum number of concurrent SSL-VPN connections.
ssl_vpntextIndicates whether the SSL-VPN feature is enabled.
statustextThe status of the VPN gateway.
tagtextThe tag of the VPN gateway.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags attached with the resource.
titletextTitle of the resource.
vpc_idtextThe ID of the VPC for which the VPN gateway is created.
vpn_gateway_idtextThe ID of the VPN gateway.
vswitch_idtextThe ID of the VSwitch to which the VPN gateway belongs.