Query: compute_virtual_machine_storage_profile

select
  os_disk_name as "Disk Name",
  os_disk_caching as "Disk Caching",
  os_disk_create_option as "Disk Create Option",
  os_disk_vhd_uri as "Virtual Hard Disk URI",
  lower(d.id) as "ID"
from
  azure_compute_virtual_machine as vm
  left join azure_compute_disk as d on  vm.os_disk_name = d.name  and lower(vm.id)= lower(d.managed_by)
where
  lower(vm.id) = $1
  and vm.subscription_id = split_part($1, '/', 3);