turbot/oci_insights

Query: compartment_table

Usage

powerpipe query oci_insights.query.compartment_table

SQL

select
c.name as "Name",
c.lifecycle_state as "Lifecycle State",
c.time_created as "Time Created",
t.name as "Tenancy Name"
from
oci_identity_compartment as c
left join oci_identity_tenancy as t on t.id = c.tenant_id;

Dashboards

The query is used in the dashboards: