turbot/oci_insights

Query: vcn_cidr_blocks

Usage

powerpipe query oci_insights.query.vcn_cidr_blocks

Steampipe Tables

SQL

select
b as "CIDR Block",
power(2, 32 - masklen(b :: cidr)) as "Total IPs"
from
oci_core_vcn,
jsonb_array_elements_text(cidr_blocks) as b
where
id = $1
union all
select
b as cidr_block,
power(2, 128 - masklen(b :: cidr)) as num_ips
from
oci_core_vcn,
jsonb_array_elements_text(ipv6_cidr_blocks) as b
where
id = $1;

Dashboards

The query is used in the dashboards: