turbot/oci_insights

Query: vcn_subnets_for_filestorage_file_system

Usage

powerpipe query oci_insights.query.vcn_subnets_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
subnet_id
from
file_system_export_ids as e,
oci_file_storage_mount_target as m
where
e.export_set_id = m.export_set_id;