turbot/oci_insights

Query: vcn_ipv4_count

Usage

powerpipe query oci_insights.query.vcn_ipv4_count

Steampipe Tables

SQL

with cidrs as (
select
power(2, 32 - masklen(b :: cidr)) as num_ips
from
oci_core_vcn,
jsonb_array_elements_text(cidr_blocks) as b
where
id = $1
)
select
sum(num_ips) as "IPv4 Addresses"
from
cidrs;

Dashboards

The query is used in the dashboards: