turbot/oci_insights

Query: vcn_load_balancers_for_vcn_vcn

Usage

powerpipe query oci_insights.query.vcn_load_balancers_for_vcn_vcn

SQL

select
lb.id as load_balancer_id
from
oci_core_load_balancer as lb,
jsonb_array_elements_text(subnet_ids) as sid,
oci_core_subnet as s
where
sid = s.id
and s.vcn_id = $1;