turbot/oci_insights

Query: oci_vcn_security_list_by_vcn

Usage

powerpipe query oci_insights.query.oci_vcn_security_list_by_vcn

SQL

select
v.display_name as "VCN",
count(*) as "security_lists"
from
oci_core_security_list sg
left join oci_core_vcn v on sg.vcn_id = v.id
where
sg.lifecycle_state <> 'TERMINATED'
group by
v.display_name
order by
v.display_name;

Dashboards

The query is used in the dashboards: