turbot/oci_insights

Query: compute_instance_security_groups

Usage

powerpipe query oci_insights.query.compute_instance_security_groups

SQL

select
sg.display_name as "Group Name",
nid as "Group ID",
jsonb_array_length(sg.rules) as "Rules"
from
oci_core_vnic_attachment,
jsonb_array_elements_text(nsg_ids) as nid
left join oci_core_network_security_group as sg on sg.id = nid
where
instance_id = $1;

Dashboards

The query is used in the dashboards: