turbot/oci_insights

Query: vcn_load_balancers_for_compute_instance

Usage

powerpipe query oci_insights.query.vcn_load_balancers_for_compute_instance

SQL

select
lb.id as lb_id
from
oci_core_vnic_attachment as a,
oci_core_load_balancer as lb,
jsonb_array_elements_text(subnet_ids) as sid
where
a.subnet_id = sid
and a.instance_id = $1;