How to find Windows version on Virtual Machines through Azure portal-CodePudding

How can I find what windows version is running on my Virtual Machines through Azure portal?

We have about 60 resource groups with virtual machines and we are planning to upgrade all Windows server 2012, but first we need an overview of how many machines we have running with server 2012.

By googling I only found this prameter, but it only gives me if it's Windows or Linux. How can I get windows version as well?

properties.storageProfile.osDisk.osType

CodePudding user response：

If you want to pull the windows versions of your virtual machines, you can below resource graph explorer query from the portal.

Here is the sample query:

resources
| where type == "microsoft.compute/virtualmachines"  and properties.storageProfile.imageReference.offer == "WindowsServer"
| project name,offer=properties.storageProfile.imageReference.offer,sku=properties.storageProfile.imageReference.sku,version=properties.storageProfile.imageReference.version,minorversion=properties.storageProfile.imageReference.exactVersion

Here is the sample output screenshot for reference: