turbot/steampipe-mod-gcp-insights

Dashboard: GCP Compute Instance Detail

This dashboard answers the following questions for each instance:

  • How is the instance configured?
  • What relationships does the instance have with other resources?
  • What tags are applied?
  • Which disks and network interfaces are attached to the instance?
This dashboard contains 5 cards, 1 graph, 1 input and 5 tables.

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 Compute Instance Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run gcp_insights.dashboard.compute_instance_detail --share

Queries

This dashboard uses the the following queries:
select
d ->> 'deviceName' as "Device Name",
d ->> 'diskSizeGb' as "Disk Size (GB)",
d ->> 'interface' as "Interface",
d ->> 'mode' as "Mode",
d ->> 'boot' as "Boot",
d ->> 'autoDelete' as "Auto-Delete"
from
gcp_compute_instance,
jsonb_array_elements(disks) as d
where
id = (split_part($1, '/', 1))::bigint
and project = split_part($1, '/', 2);

Tags