turbot/oci_insights

Query: mysql_db_system_with_backups

Usage

powerpipe query oci_insights.query.mysql_db_system_with_backups

SQL

select
case
when b.id is null then 'disabled'
else 'enabled'
end as status,
count(distinct s.id)
from
oci_mysql_db_system as s
left join oci_mysql_backup as b on s.id = b.db_system_id
where
s.lifecycle_state <> 'DELETED'
group by
status;

Dashboards

The query is used in the dashboards: