turbot/oci_insights

Query: mysql_db_system_by_tenancy

Usage

powerpipe query oci_insights.query.mysql_db_system_by_tenancy

SQL

select
t.title as "Tenancy",
count(s.*) as "DB Systems"
from
oci_mysql_db_system as s,
oci_identity_tenancy as t
where
t.id = s.tenant_id
and lifecycle_state <> 'DELETED'
group by
t.title
order by
t.title;

Dashboards

The query is used in the dashboards: