turbot/steampipe-mod-oci-insights

Dashboard: OCI MySQL DB System Detail

This dashboard contains 2 cards, 1 graph, 1 input and 4 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-oci-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select OCI MySQL DB System Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run oci_insights.dashboard.mysql_db_system_detail --share

Queries

This dashboard uses the the following queries:
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;

Tags