turbot/oci_insights

Query: oci_vcn_security_groups_by_region

Usage

powerpipe query oci_insights.query.oci_vcn_security_groups_by_region

SQL

select
region as "Region",
count(*) as "Security Groups"
from
oci_core_network_security_group
where
lifecycle_state <> 'TERMINATED'
group by
region
order by
region;

Dashboards

The query is used in the dashboards: