GCP Compute Disk Age ReportGCP Compute Disk DashboardGCP Compute Disk DetailGCP Compute Disk Encryption ReportGCP Compute Instance Age ReportGCP Compute Instance DashboardGCP Compute Instance DetailGCP Compute Instance Group DetailGCP Compute Network DashboardGCP Compute Network DetailGCP Compute Subnetwork DetailGCP IAM Service Account DetailGCP IAM Service Account Key Age ReportGCP KMS Key Age ReportGCP KMS Key DashboardGCP KMS Key DetailGCP Kubernetes Cluster Age ReportGCP Kubernetes Cluster DashboardGCP Kubernetes Cluster DetailGCP Project ReportGCP Pub/Sub Topic DetailGCP SQL Database Instance DashboardGCP SQL Database Instance DetailGCP Storage Bucket Age ReportGCP Storage Bucket DashboardGCP Storage Bucket DetailGCP Storage Bucket Encryption Report
Dashboard: GCP SQL Database Instance Dashboard
This dashboard answers the following questions:
- How many instances are in each project and location?
- How many unencrypted and publicly accessible instances are there?
- How many instances have backup and point-in-recovery enabled?
- How many instances have ssl enabled?
- How many read replicas does each instance have?
- How many instances are in each database type?
This dashboard contains 6 cards.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gcp-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select GCP SQL Database Instance Dashboard dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run gcp_insights.dashboard.sql_database_instance_dashboard --shareQueries
The dashboard uses the named queries:
- sql_database_instance_backup_enabled_count
- sql_database_instance_backup_status
- sql_database_instance_by_database_version
- sql_database_instance_by_location
- sql_database_instance_by_project
- sql_database_instance_by_replica
- sql_database_instance_by_state
- sql_database_instance_count
- sql_database_instance_encryption_count
- sql_database_instance_encryption_status
- sql_database_instance_point_in_time_recovery_enable_count
- sql_database_instance_point_in_time_recovery_status
- sql_database_instance_public_access_count
- sql_database_instance_public_access_status
- sql_database_instance_ssl_enabled_count
- sql_database_ssl_status