turbot/oci_insights

Query: filestorage_mount_targets_for_filestorage_file_system

Usage

powerpipe query oci_insights.query.filestorage_mount_targets_for_filestorage_file_system

SQL

with export_ids as (
select
jsonb_array_elements(exports) ->> 'exportSetId' as export_set_id
from
oci_file_storage_file_system
where
id = $1
)
select
m.id as mount_target_id
from
export_ids as e,
oci_file_storage_mount_target as m
where
e.export_set_id = m.export_set_id;