turbot/oci_insights

Query: vcn_network_security_groups_for_filestorage_file_system

Usage

powerpipe query oci_insights.query.vcn_network_security_groups_for_filestorage_file_system

SQL

with file_system_export_ids as (
select
jsonb_array_elements(exports) ->> 'exportSetId' as export_set_id
from
oci_file_storage_file_system
where
id = $1
)
select
nid as security_group_id
from
file_system_export_ids as e,
oci_file_storage_mount_target as m,
jsonb_array_elements_text(nsg_ids) as nid
where
e.export_set_id = m.export_set_id;