Azure Resource Graph Explorer

Question

Azure Resource Graph Explorer

M, RAKESH 121

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

Ex: Linux (oracle 8.5)

Prrudram-MSFT 28,201 Reputation points Moderator

2022-04-13T17:02:26.637+00:00

Hello @M, RAKESH ,

Just checking in to see if you got a chance to see my response and if it helped, I would request you to "Accept Answer and Upvote" so that the relevancy of this post will improve when anyone in the community search for a similar query.

What is the importance of accepting answers in case they helped you:-
You as an original poster by accepting answers will be helping other community members in finding the appropriate solutions in an effective way.

2 answers

Your answer

Prrudram-MSFT 28,201 Reputation points Moderator

2022-04-13T17:02:26.637+00:00

Hello @M, RAKESH ,

Just checking in to see if you got a chance to see my response and if it helped, I would request you to "Accept Answer and Upvote" so that the relevancy of this post will improve when anyone in the community search for a similar query.

What is the importance of accepting answers in case they helped you:-
You as an original poster by accepting answers will be helping other community members in finding the appropriate solutions in an effective way.

Answer 1

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.

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

Reference : https://learn.microsoft.com/en-us/azure/governance/resource-graph/first-query-portal

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

Answer 2

Rajesh Sridharan 0

How to pull only for linux?

Share via

Azure Resource Graph Explorer

2 answers

Your answer