turbot/alicloud_insights

Query: vpc_ipv6_count

Usage

powerpipe query alicloud_insights.query.vpc_ipv6_count

Steampipe Tables

SQL

with cidrs as (
select
power(2, 128 - masklen((b ->> 'Ipv6CidrBlock'):: cidr)) as num_ips
from
alicloud_vpc,
jsonb_array_elements(ipv6_cidr_blocks) as b
where
vpc_id = $1
)
select
sum(num_ips) as "IPv6 Addresses"
from
cidrs;

Dashboards

The query is used in the dashboards: