turbot/ibm_insights

Query: ibm_is_vpc_by_account

Usage

powerpipe query ibm_insights.query.ibm_is_vpc_by_account

Steampipe Tables

SQL

select
a.name as "account",
count(v.*) as "VPCs"
from
ibm_is_vpc as v,
ibm_account as a
where
v.account_id = a.customer_id
group by
account
order by
account;

Dashboards

The query is used in the dashboards: