turbot/ibm_insights

Query: ibm_is_vpc_age_table

Usage

powerpipe query ibm_insights.query.ibm_is_vpc_age_table

Steampipe Tables

SQL

select
v.name as "Name",
now() :: date - v.created_at :: date as "Age in Days",
v.created_at as "Create Time",
v.status as "Status",
a.name as "Account",
v.account_id as "Account ID",
v.region as "Region",
v.crn as "CRN"
from
ibm_is_vpc as v,
ibm_account as a
where
v.account_id = a.customer_id
order by
v.name;

Dashboards

The query is used in the dashboards: