turbot/oci_insights

Query: mysql_db_system_backup_disabled_count

Usage

powerpipe query oci_insights.query.mysql_db_system_backup_disabled_count

SQL

select
count(s.*) as value,
'Backups Disabled' as label,
case
count(*)
when 0 then 'ok'
else 'alert'
end as type
from
oci_mysql_db_system as s
left join oci_mysql_backup as b on s.id = b.db_system_id
where
b.id is null
and s.lifecycle_state <> 'DELETED';

Dashboards

The query is used in the dashboards: