Query: oci_vcn_security_groups_by_region

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