azure kql 从 VMSS 获取 OSversion 和 OSName

Question

resources
 | where type == "microsoft.compute/virtualmachinescalesets"
 | extend
extensions = properties.virtualMachineProfile.extensionProfile.extensions,
osName = properties.virtualMachineProfile.storageProfile.osDisk.osName,
osVersion = properties.virtualMachineProfile.storageProfile.osDisk.osVersion,
osType = properties.virtualMachineProfile.storageProfile.osDisk.osType

我可以获得“Linux”的 osType，但是我想要 OSName(例如 ubuntu、Redhut)osVersion(如版本 18、19)
我需要做什么才能得到它。

Answer 1

resources
|   where   type == "microsoft.compute/virtualmachinescalesets"
|   extend  publisher   = properties.virtualMachineProfile.storageProfile.imageReference.publisher
           ,version     = properties.virtualMachineProfile.storageProfile.imageReference.version
           ,sku         = properties.virtualMachineProfile.storageProfile.imageReference.sku
           ,offer       = properties.virtualMachineProfile.storageProfile.imageReference.offer

附注

这是一个您可能会觉得有用的“工具”:

resources
| where type == "microsoft.compute/virtualmachinescalesets"
| where * has "ubuntu"