turbot/gcp_insights

Query: auto_create_subnetwork

Usage

powerpipe query gcp_insights.query.auto_create_subnetwork

Steampipe Tables

SQL

select
'Auto Create Subnetwork' as label,
case when auto_create_subnetworks then 'Enabled' else 'Disabled' end as value,
case when auto_create_subnetworks and name = 'default' then 'ok' else 'alert' end as type
from
gcp_compute_network
where
id = (split_part($1, '/', 1))::bigint
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: