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 Age Report
This report answers the following questions:
- How old are my DB systems?
- What state are they in?
This dashboard contains 6 cards and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-oci-insights
Start the Powerpipe server:
steampipe service startpowerpipe server
Open http://localhost:9033 in your browser and select OCI MySQL DB System Age Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run oci_insights.dashboard.mysql_db_system_age_report --share
Queries
The dashboard uses the named queries:
- mysql_db_system_1_year
- mysql_db_system_24_hrs
- mysql_db_system_30_days
- mysql_db_system_365_days
- mysql_db_system_90_days
- mysql_db_system_age_report
- mysql_db_system_count