Resource Graph Query to fetch VM details with Data disk

@Senthilnath TM Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Based on shared information, I understand you want to pull the data disks that were attached to virtual machine using the Azure Resource graph explorer by joining the Microsoft.compute/virtualMachines and microsoft.compute/disks types.

Resource graph explorer supports Joins you can refer to sample queries in this documentation on how to use joins.

If my understanding is correct, then you can use the below queries to achieve your requirement directly instead of using joins.

Query 1:

In this we are listing all disks (Microsoft.compute/disks) under the subscription and then by using the property ManagedBy we are able to pull the Virtual Machine Name to which this particular disk is attached to.

resources
| where ['type'] =~ 'microsoft.compute/disks' and properties !contains "osType" 
| extend VmName= split(managedBy,'/virtualMachines/')
| project  DiskName=name,VMName=VmName[1], datadisksresourceId=['id']

Query 2:

As you know that disk information is stored under storageProfile property at virtual machine level we are using the same and pulling the data disks information from it.

resources
| where type =~ 'Microsoft.Compute/virtualMachines'
| extend disklists = properties.storageProfile.dataDisks
| mv-expand disklists
| project name, diskId = disklists

Here is the sample response for the second query.

If you still want to pull this information using Joins please share the query that you have build so that we can test and assist you further on this.

Hope this helps let me if you have any further questions on this.

@VenkateshDodda-MSFT Thanks for the query but i missed to add that i also need the VM size from the query results for which i tried to join. How can this be achieved?

@Senthilnath TM Thanks for your follow-up questions you can modify the Query 2 to below include the vmsize details in the output.

VM sku details are stored under hardwareprofile.

resources
| where type =~ 'Microsoft.Compute/virtualMachines'
| extend disklists = properties.storageProfile.dataDisks
| mv-expand disklists
| project name, diskname=disklists.name , skusize = properties.hardwareProfile.vmSize,diskId = disklists