turbot/oci_insights

Query: vcn_network_security_group_egress_rule

Usage

powerpipe query oci_insights.query.vcn_network_security_group_egress_rule

SQL

select
r ->> 'protocol' as "Protocol",
r ->> 'destination' as "Destination",
r ->> 'isStateless' as "Stateless",
r ->> 'isValid' as "Valid"
from
oci_core_network_security_group,
jsonb_array_elements(rules) as r
where
r ->> 'direction' = 'EGRESS'
and id = $1
and lifecycle_state <> 'TERMINATED';

Dashboards

The query is used in the dashboards: