turbot/oci_insights

Dashboard: OCI MySQL DB System Dashboard

This dashboard answers the following questions:

  • How many DB systems are in each tenancy, compartment, and region?
  • How much storage is allocated across all DB systems?
  • How many analytics and heatwave clusters are attached to DB systems?
  • How many DB systems do not have backups?
  • What are my most used DB systems in terms of CPU utilization?
This dashboard contains 5 cards.

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 Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

The dashboard uses the named queries:

Tags