turbot/steampipe-mod-gcp-insights

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 dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-gcp-insights

Start the Powerpipe server:

steampipe service start
powerpipe 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 login
powerpipe 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;

Tags