Query: ibm_compute_instance_disk_attached_instances

select
  i.name as "Instance Name",
  i.id as "Instance ID",
  i.crn as "CRN",
  i.status as "Status",
  i.created_at as "Create Time"
from
  ibm_is_instance_disk as d,
  ibm_is_instance as i
where
  d.instance_id = i.id
  and d.id = $1
order by
  i.name;