turbot/azure_insights

Query: compute_virtual_machine_scale_set_vms_for_kubernetes_cluster

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_set_vms_for_kubernetes_cluster

SQL

select
lower(vm.id) as vm_id
from
azure_kubernetes_cluster c,
azure_compute_virtual_machine_scale_set
set
,
azure_compute_virtual_machine_scale_set_vm vm
where
lower(
set
.resource_group
) = lower(c.node_resource_group)
and
set
.name = vm.scale_set_name
and vm.resource_group =
set
.resource_group
and lower(c.id) = $1;