GCP Compute Disk Age ReportGCP Compute Disk DashboardGCP Compute Disk DetailGCP Compute Disk Encryption ReportGCP Compute Disk Inventory ReportGCP Compute Instance Age ReportGCP Compute Instance DashboardGCP Compute Instance DetailGCP Compute Instance Group DetailGCP Compute Instance Inventory ReportGCP Compute Network DashboardGCP Compute Network DetailGCP Compute Subnetwork DetailGCP IAM Service Account DetailGCP IAM Service Account Inventory ReportGCP IAM Service Account Key Age ReportGCP KMS Key Age ReportGCP KMS Key DashboardGCP KMS Key DetailGCP KMS Key Inventory ReportGCP Kubernetes Cluster Age ReportGCP Kubernetes Cluster DashboardGCP Kubernetes Cluster DetailGCP Kubernetes Cluster Inventory ReportGCP Project ReportGCP Pub/Sub Topic DetailGCP SQL Database Instance DashboardGCP SQL Database Instance DetailGCP SQL Database Instance Inventory ReportGCP Storage Bucket Age ReportGCP Storage Bucket DashboardGCP Storage Bucket DetailGCP Storage Bucket Encryption ReportGCP Storage Bucket Inventory Report
Dashboard: GCP SQL Database Instance Inventory Report
This report answers the following questions:
- How many SQL database instances are there across my projects?
- When were the instances created?
- What database versions are being used?
- What is the operational state of each instance?
- What instance types and machine types are being used?
- Which instances have high availability configuration?
- What backup and recovery options are enabled?
- What type of encryption is used (Google-managed vs Customer-managed)?
- What labels are applied to each instance?
- How are instances distributed across projects and locations?
This dashboard contains 1 card and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gcp-insights
Start the Powerpipe server:
steampipe service startpowerpipe server
Open http://localhost:9033 in your browser and select GCP SQL Database Instance Inventory Report dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run gcp_insights.dashboard.sql_database_instance_inventory_report --share
Queries
This dashboard uses the the following queries:
select count(*) as "Instances" from gcp_sql_database_instance;