turbot/oci_insights

Query: mysql_db_system_backup

Usage

powerpipe query oci_insights.query.mysql_db_system_backup

SQL

select
'Backup Status' as label,
case
when b.id is null then 'Disabled'
else 'Enabled'
end as value,
case
when b.id is null then 'alert'
else 'ok'
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
s.id = $1;

Dashboards

The query is used in the dashboards: