turbot/azure_insights

Query: compute_virtual_machine_storage_profile

Usage

powerpipe query azure_insights.query.compute_virtual_machine_storage_profile

SQL

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;

Dashboards

The query is used in the dashboards: