turbot/oci_insights

Query: vcn_network_security_group_ingress_rules_count

Usage

powerpipe query oci_insights.query.vcn_network_security_group_ingress_rules_count

SQL

select
'Ingress Rules' as label,
count(*) as value
from
oci_core_network_security_group,
jsonb_array_elements(rules) as r
where
r ->> 'direction' = 'INGRESS'
and id = $1;

Dashboards

The query is used in the dashboards: