Query: blockstorage_boot_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_boot_volume_attachment as a
  left join oci_core_instance as i on a.instance_id = i.id
where
  a.boot_volume_id = $1 and a.lifecycle_state <> 'TERMINATED';