turbot/azure_insights

Query: compute_virtual_machine_scale_set_vm_image_reference

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_set_vm_image_reference

SQL

select
virtual_machine_storage_profile -> 'imageReference' ->> 'offer' as "Offer",
virtual_machine_storage_profile -> 'imageReference' ->> 'publisher' as "Publisher",
virtual_machine_storage_profile -> 'imageReference' ->> 'sku' as "SKU",
virtual_machine_storage_profile -> 'imageReference' ->> 'version' as "Version"
from
azure_compute_virtual_machine_scale_set_vm
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: