turbot/oci_insights

Query: oci_vcn_by_tenancy

Usage

powerpipe query oci_insights.query.oci_vcn_by_tenancy

SQL

select
c.title as "Compartment",
count(v.*) as "VCNs"
from
oci_core_vcn as v,
oci_identity_tenancy as c
where
c.id = v.tenant_id
and lifecycle_state <> 'TERMINATED'
group by
c.title
order by
c.title;

Dashboards

The query is used in the dashboards: