turbot/steampipe-mod-gcp-insights

Query: compute_instance_inventory_table

Usage

powerpipe query gcp_insights.query.compute_instance_inventory_table

SQL

select
i.name as "Name",
i.creation_timestamp as "Creation Time",
i.status as "Status",
i.machine_type_name as "Machine Type",
i.deletion_protection as "Deletion Protection",
i.can_ip_forward as "IP Forwarding",
i.network_tags as "Network Tags",
i.labels as "Labels",
i.id::text as "ID",
p.name as "Project",
i.location as "Location"
from
gcp_compute_instance as i,
gcp_project as p
where
p.project_id = i.project
order by
i.name;

Dashboards

The query is used in the dashboards: