turbot/gcp_insights

Query: compute_instance_network_interfaces

Usage

powerpipe query gcp_insights.query.compute_instance_network_interfaces

Steampipe Tables

SQL

select
nic ->> 'name' as "Name",
nic ->> 'networkIP' as "Internal IP",
nic ->> 'stackType' as "Stack Type",
ac ->> 'natIP' as "External IP",
ac ->> 'networkTier' as "Network Tier",
can_ip_forward as "IP Forwarding"
from
gcp_compute_instance,
jsonb_array_elements(network_interfaces) as nic,
jsonb_array_elements(nic -> 'accessConfigs') ac
where
id = (split_part($1, '/', 1))::bigint
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: