Query: blockstorage_block_volume_attached_instances

select
  i.id as "Instance ID",
  i.display_name as "Instance Name",
  i.lifecycle_state as "Lifecycle State",
  a.time_created as "Attachment Time"
from
  oci_core_volume_attachment as a
  left join oci_core_instance as i on a.instance_id = i.id
where
  a.volume_id = $1;