turbot/gcp_insights

Query: compute_backend_services_for_compute_network

Usage

powerpipe query gcp_insights.query.compute_backend_services_for_compute_network

SQL

with compute_backend_service as (
select
id,
network
from
gcp_compute_backend_service
), compute_network as (
select
self_link,
id
from
gcp_compute_network
where
id = (split_part($1, '/', 1))::bigint
and project = split_part($1, '/', 2)
)
select
bs.id::text as service_id
from
compute_backend_service bs,
compute_network n
where
bs.network = n.self_link;