How to get a list of replicated disks associated with virtual machines in Azure using Azure Resource Graph query?

Monitor 2512 5

How can I use Azure Resource Graph to query for virtual machines and their associated replicated disks in Azure? I would also like to include the tag information for both the virtual machines and their replicated disks.

Srinud 2,610 Reputation points Microsoft Vendor

2024-10-01T23:31:32.69+00:00

Hi Monitor 2512,

Welcome to the Microsoft Q&A Platform. Thank you for posting your query here. We are looking into it and will get back to you soon. Thank you.
Srinud 2,610 Reputation points Microsoft Vendor

2024-10-02T04:41:14.2566667+00:00
Hi Monitor 2512,

To get a list of virtual machines and their associated replicated disks in Azure, including tag information, you can use the following Azure Resource Graph query:

Resources | where type =~ 'microsoft.compute/virtualMachines' or type =~ 'microsoft.compute/disks' | join ( Resources | where type =~ 'microsoft.compute/disks' | extend vmId = parse_json(properties).managedBy ) on $left.id == $right.vmId | project name, type, location, tags, properties | extend vmTags = parse_json(properties).tags, diskTags = parse_json(properties).tags | project name, type, location, vmTags, diskTags

You can run this query in the Azure Resource Graph Explorer or using the Azure CLI with the az graph command.

For more detailed examples, please refer to the Azure Resource Graph sample queries for Azure Virtual Machines.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If this information is helpful, we would appreciate it if you could click the Upvote on this post.

Thank you.
Srinud 2,610 Reputation points Microsoft Vendor

2024-10-07T19:14:48.3133333+00:00

Hi Monitor,

Just checking in to see if you have got a chance to see the comment posted by in resolving the issue.

If the information is helpful, please consider by clicking the "Upvote" on the post.

Thank you.
Srinud 2,610 Reputation points Microsoft Vendor

2024-10-08T18:40:15.9+00:00

Hi Monitor,

Just checking in to see if you have got a chance to see the comment posted by in resolving the issue.

If the information is helpful, please consider by clicking the "Upvote" on the post.

Thank you.
Monitor 2512 5 Reputation points

2024-10-21T17:54:17.1333333+00:00

Hi @Srinud

My query to get the list of Replica disks associated with the Virtual machines not attached state disks
Above query provides attached state disks

1 answer

Srinud 2,610 Microsoft Vendor

Hi Monitor,

Could you please try the query below. Make sure to adjust the query according to your data.

Resources
| where type =~ 'microsoft.compute/virtualMachines' or type =~ 'microsoft.compute/disks'
| project id, name, type, resourceGroup, location, tags, properties
| join (
    Resources
    | where type =~ 'microsoft.compute/disks' and properties.replicationStatus =~ 'Replicating'
    | project diskId, vmId, diskName, diskTags, properties
) on id
| project vmId, vmName = name, vmTags = tags, vmLocation = location, vmResourceGroup = resourceGroup, vmType = type, vmProperties = properties, diskId, diskName, diskTags, diskLocation = location, diskResourceGroup = resourceGroup, diskType = type, diskProperties = properties

If the information is helpful, please consider by clicking the "Accept answer and Upvote" on the post. If you are still facing any issue, please let us know in the comments.

Thank you.

Share via

How to get a list of replicated disks associated with virtual machines in Azure using Azure Resource Graph query?

1 answer

Your answer