turbot/ibm_insights

Query: ibm_is_vpc_num_ips_for_vpc

Usage

powerpipe query ibm_insights.query.ibm_is_vpc_num_ips_for_vpc

Steampipe Tables

SQL

with cidrs as (
select
a ->> 'cidr' as cidr_block,
masklen(( a ->> 'cidr')::cidr) as "Mask Length",
power(2, 32 - masklen( (a ->> 'cidr'):: cidr)) as num_ips
from
ibm_is_vpc,
jsonb_array_elements(address_prefixes) as a
where crn = $1
)
select
sum(num_ips) as "IP Addresses"
from
cidrs;

Params

ArgsNameDefaultDescriptionVariable
$1crn

    Dashboards

    The query is used in the dashboards: