Export Azure VM Info

Irakli 0

Hello,

I would like to export list of virtual machines & their corresponding: Name, IP, Type (Windows or Linux for example), CPU, RAM, HDD\SSD and Tag

As I know it is possible with Azure Resource Graph, but when I tried applied filters I cant see anything... How do I should write script correct?

Thanks in advance.

Mahesh Goud Juvvadi 980 Reputation points Microsoft Vendor

2024-10-03T05:47:46.82+00:00
Hi Irakli,

Thank you for reaching out to the Microsoft Q&A platform.

Yes, use the Azure Resource Graph Explorer to export VM configuration data, including CPU, RAM, OS disk size.

The Azure Resource Graph Explorer allows you to run Kusto Query Language (KQL) queries against your Azure resources and export the results to a CSV file.To export VM configuration data using the Azure Resource Graph Explorer, you can follow these steps:

Open the Azure Resource Graph Explorer in the Azure portal.

Write a KQL query to retrieve the VM configuration data. Here's an example query:
Resources | where type == 'microsoft.compute/virtualmachines' | extend vmSize = tostring(properties.hardwareProfile.vmSize) | extend osDiskSize = tostring(properties.storageProfile.osDisk.diskSizeGB) | extend dataDiskSize = tostring(properties.storageProfile.dataDisks[0].diskSizeGB) | project name, vmSize, osDiskSize, dataDiskSize

This query retrieves all virtual machines in your subscription and projects the name, VM size, OS disk size.

Run the query and export the results to a CSV file. To export the results to a CSV file, click the "Export" button in the Azure Resource Graph Explorer and select "CSV (current view)".

Open the CSV file in Excel or another spreadsheet program to view and analyze the data. I hope this helps! Let me know if you have any other questions.

Please refer the document for your reference: Azure Resource Graph sample queries for Azure Virtual Machines

If it was helpful, please click "Upvote" on his post to let us know.

Thank You.
Irakli 0 Reputation points

2024-10-03T10:22:26.9966667+00:00

Thanks for your reply, how I can also add network settings output?

Do I need "join kind=leftouter"?

1 answer

Irakli 0 Reputation points

2024-10-02T12:31:33.96+00:00

Resources

| where type == 'microsoft.compute/virtualmachines'

| extend

OSName = tostring(properties.osProfile.computerName),

OSType = tostring(properties.storageProfile.osDisk.osType),

VMSize = tostring(properties.hardwareProfile.vmSize)

| join kind=leftouter

( Resources

| where type =~ 'microsoft.network/networkinterfaces'

not sure what is the next and how to select cpu\ram...
Please sign in to rate this answer.
Irakli 0 Reputation points

2024-10-03T10:53:38.9566667+00:00

I tried in this way but I see errors

resources

| where type == 'microsoft.compute/virtualmachines'

| extend vmSize = tostring(properties.hardwareProfile.vmSize)

| extend vmType = tostring(properties.storageProfile.osDisk.osType)

| extend osDiskSize = tostring(properties.storageProfile.osDisk.diskSizeGB)

| extend dataDiskSize = tostring(properties.storageProfile.dataDisks[0].diskSizeGB)

| project resourceGroup, name, vmType, osDiskSize, dataDiskSize

| join kind=leftouter

resources

| where type =~ 'microsoft.network/networkinterfaces'

| project id, ipConfigurations = properties.ipConfigurations

| mvexpand ipConfigurations

| project id, subnetId = tostring(ipConfigurations.properties.subnet.id)

| parse kind=regex subnetId with '/virtualNetworks/' virtualNetwork '/subnets/' subnet

| project id, virtualNetwork, subnet
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Export Azure VM Info

1 answer

Your answer