OCI Block Storage Block Volume Age ReportOCI Block Storage Block Volume DashboardOCI Block Storage Block Volume DetailOCI Block Storage Block Volume Encryption ReportOCI Block Storage Block Volume Unattached ReportOCI Block Storage Boot Volume Age ReportOCI Block Storage Boot Volume DashboardOCI Block Storage Boot Volume DetailOCI Block Storage Boot Volume Encryption ReportOCI Block Storage Boot Volume Unattached ReportOCI Compartment ReportOCI Compute Instance Age ReportOCI Compute Instance DashboardOCI Compute Instance DetailOCI Database Autonomous DB Age ReportOCI Database Autonomous DB DashboardOCI Database Autonomous DB DetailOCI File Storage File System Age ReportOCI File Storage File System DashboardOCI File Storage File System DetailOCI Identity API Key Age ReportOCI Identity Customer Secret Key Age ReportOCI Identity Group DashboardOCI Identity Group DetailOCI Identity User DashboardOCI Identity User DetailOCI Identity User MFA ReportOCI KMS Key Age ReportOCI KMS Key DashboardOCI KMS Key DetailOCI KMS Vault Age ReportOCI KMS Vault DashboardOCI KMS Vault DetailOCI MySQL Backup Age ReportOCI MySQL Backup DashboardOCI MySQL DB System Age ReportOCI MySQL DB System DashboardOCI MySQL DB System DetailOCI NoSQL Table Age ReportOCI NoSQL Table DashboardOCI NoSQL Table DetailOCI Object Storage Bucket Age ReportOCI Object Storage Bucket DashboardOCI Object Storage Bucket DetailOCI Object Storage Bucket Encryption ReportOCI Object Storage Bucket Lifecycle ReportOCI Object Storage Bucket Logging ReportOCI Object Storage Bucket Public Access ReportOCI ONS Notification Topic Age ReportOCI ONS Notification Topic DashboardOCI ONS Notification Topic DetailOCI ONS Subscription Age ReportOCI ONS Subscription DashboardOCI Tenancy ReportOCI VCN DashboardOCI VCN DetailOCI VCN Network Security Group DashboardOCI VCN Network Security Group DetailOCI VCN Network Security List DashboardOCI VCN Security List DetailOCI VCN Subnet DashboardOCI VCN Subnet DetailOCI VCN Subnet Flow Logs Report
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 dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-oci-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen 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 loginpowerpipe dashboard run oci_insights.dashboard.mysql_db_system_dashboard --shareQueries
The dashboard uses the named queries:
- mysql_db_system_analytics_cluster_attached_count
- mysql_db_system_backup_disabled_count
- mysql_db_system_by_compartment
- mysql_db_system_by_cpu_utilization_category
- mysql_db_system_by_creation_month
- mysql_db_system_by_region
- mysql_db_system_by_tenancy
- mysql_db_system_count
- mysql_db_system_heat_wave_cluster_attached_count
- mysql_db_system_storage_by_compartment
- mysql_db_system_storage_by_creation_month
- mysql_db_system_storage_by_region
- mysql_db_system_storage_by_tenancy
- mysql_db_system_storage_total
- mysql_db_system_top10_cpu_past_week
- mysql_db_system_with_backups