Azure Resource Graph Explorer

M, RAKESH 111 Reputation points

How to get the all the VMs operating system and version details using Azure Resource Graph Explorer.

Ex: Linux (oracle 8.5)

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,409 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Prrudram-MSFT 22,936 Reputation points

    Hello @M, RAKESH ,

    Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question. Please use the resource table in azure resource graph explorer when running the below query.

    | where type =~ 'Microsoft.Compute/virtualMachines'  
    | summarize count() by tostring(properties.storageProfile.osDisk.osType),tostring(properties.storageProfile.imageReference.offer), tostring(properties.storageProfile.imageReference.sku)  


    Reference :

    Please "Accept as Answer" and Upvote if any of the above helped to help others in the community looking for remediation for similar issues.

    1 person found this answer helpful.
    0 comments No comments

  2. Rajesh sridharan 0 Reputation points

    How to pull only for linux?

    0 comments No comments