virtual machine list export to csv
When we go to All resources we can see Export to CSV button on top menu so that all the resources can be downloaded easily.
When we go to Virtual Machine there is no such functionality available.
There are lots of scripting needs to be done to achieve this and also previously we use to be able to copy and paste it into excel and it used to copy all the columns which we've selected. But that too isn't working now.
Can you please give us the functionality to export the VM details into CSV
Thanks for the valid suggestion. Your feedback is now open for the user community to upvote which allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.
Bogdan Troncea commented
I recently came across a request like this and as a workaround you can navigate to All Resources, click on Open query > New Query and run the following query:
| where type =~ 'Microsoft.Compute/virtualMachines'
| project name, location, resourceGroup, properties.hardwareProfile.vmSize, properties.storageProfile.osDisk.osType,properties.extended.instanceView.powerState.displayStatus
Also in the following articles you can find other examples:
From here you can export to CSV
Khaleel, Rahman (ITS) commented
This is ridiculous, I have about 50 Azure VMs and spent one full day to manually document the name, VM resources, IP, disk etc. how is this a enterprise cloud if it cannot provide a simple csv extract for VMs
Vipul Dabhi commented
I think We can use Latest Feature of Azure Security Center which INVENTORY(Preview) mode.
Here we have Filter for Subscriptions as well as for the type of Workload(Which can be Virtual Machine) under Resource Groups under Subscription.
After Applying Filter we have a option of downloading it in CSV format respectively.
a standard GUI export function is important for admin purpose.. but it was missing for a long time
Since one cannot sort the VM list in the portal by 'size', being able to export so we could sort by whatever criteria we needed would be tremendously helpful.
Darien Allen commented
I came today to make this same request. I see that someone referenced using the view all resources screen, that generally doesn't work though for the following reason. The all resources screen isn’t very useful when it comes to exporting additional VM details because those columns aren't available... only on the virtual machine screen can you add columns like ip address, resource group, status, etc, info that you'd generally want to export along with the VM's name.
The workaround I used to accomplish this was to go view all resources, then change the filter drop-down for 'type ==' uncheck 'select all' and check 'virtual machine'. now you can export your entire vm list.
Totally agree, we need the ability to copy data in excel or have export CSV option under VM Tab. Its painful to run scripts everytime to export inventory.
Chanikya Gattamaneni commented
Thanks for posting such a Useful information .You done a great job.
Kunal Chandratre commented
For now you can use below sample to export list of Azure VMs to CSV - https://sanganakauthority.blogspot.com/2019/09/azure-vms-export-to-csv.html
Aquib Qureshi commented
Hi Team, I think this is under virtual machine category of user voice and it should be present in Azure Portal Category. Can you help me move this?
the export function is very important, as below info was showing in virtual machine page but missing from the export function in "all resource" page
1) Machine Status, 2) Resource Group, 3) IP Address, 4) Size
more VM info, e.g. harddisk type and size also nice to including in the VM export function.