turbot/azure_insights

Query: compute_disks_for_compute_virtual_machine_scale_set_vm

Usage

powerpipe query azure_insights.query.compute_disks_for_compute_virtual_machine_scale_set_vm

SQL

select
lower(d.id) as disk_id
from
azure_compute_virtual_machine_scale_set_vm as vm,
jsonb_array_elements(virtual_machine_storage_profile -> 'dataDisks') as disk
left join azure_compute_disk as d on lower(d.id) = lower(disk -> 'managedDisk' ->> 'id')
where
d.id is not null
and lower(vm.id) = $1;