turbot/oci_insights

Query: vcn_network_security_list_egress_rule

Usage

powerpipe query oci_insights.query.vcn_network_security_list_egress_rule

Steampipe Tables

SQL

select
r ->> 'protocol' as "Protocol",
r ->> 'destination' as "Destination",
r ->> 'isStateless' as "Stateless"
from
oci_core_security_list,
jsonb_array_elements(egress_security_rules) as r
where
id = $1
and lifecycle_state <> 'TERMINATED';

Dashboards

The query is used in the dashboards: