turbot/ibm_insights

Query: ibm_is_vpc_empty_status

Usage

powerpipe query ibm_insights.query.ibm_is_vpc_empty_status

Steampipe Tables

SQL

with by_empty as (
select
vpc.id,
case when s.id is null then 'empty' else 'non-empty' end as status
from
ibm_is_vpc as vpc
left join ibm_is_subnet as s on vpc.id = s.vpc ->> 'id'
)
select
status,
count(*)
from
by_empty
group by
status;

Dashboards

The query is used in the dashboards: