turbot/steampipe-mod-azure-insights

Query: compute_virtual_machine_scale_sets_for_compute_virtual_machine_scale_set_vm

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_sets_for_compute_virtual_machine_scale_set_vm

SQL

select
lower(s.id) as scale_set_id
from
azure_compute_virtual_machine_scale_set_vm as vm
left join azure_compute_virtual_machine_scale_set as s on s.name = vm.scale_set_name
where
lower(vm.id) = $1
and vm.subscription_id = split_part($1, '/', 3);