turbot/gcp_insights

Query: compute_subnetwork_network

Usage

powerpipe query gcp_insights.query.compute_subnetwork_network

SQL

select
n.name as "Name",
n.id::text as "ID",
n.creation_timestamp as "Creation Time",
n.description as "Description",
n.auto_create_subnetworks as "Auto Create Subnetworks",
n.ipv4_range as "IPv4 Range",
n.mtu as "MTU (Bytes)",
n.routing_mode as "Routing Mode"
from
gcp_compute_subnetwork s,
gcp_compute_network n
where
s.network = n.self_link
and s.id = (split_part($1, '/', 1))::bigint
and s.project = split_part($1, '/', 2);

Params

ArgsNameDefaultDescriptionVariable
$1id

    Dashboards

    The query is used in the dashboards: