turbot/alicloud_insights

Query: vpc_no_vswitch_count

Usage

powerpipe query alicloud_insights.query.vpc_no_vswitch_count

SQL

select
count(*) as value,
'VPCs Without vSwitches' as label,
case when count(*) = 0 then 'ok' else 'alert' end as type
from
alicloud_vpc as vpc
left join alicloud_vpc_vswitch as s on vpc.vpc_id = s.vpc_id
where
s.vswitch_id is null;

Dashboards

The query is used in the dashboards: