turbot/ibm_insights

Query: ibm_subnet_count_for_vpc

Usage

powerpipe query ibm_insights.query.ibm_subnet_count_for_vpc

Steampipe Tables

SQL

select
'Subnets' as label,
count(*) as value,
case
when count(*) > 0 then 'ok'
else 'alert'
end as type
from
ibm_is_subnet as s
left join ibm_is_vpc as v on v.id = s.vpc ->> 'id'
where
v.crn = $1;

Params

ArgsNameDefaultDescriptionVariable
$1crn

    Dashboards

    The query is used in the dashboards: