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
Aquib Qureshi
shared this idea
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.
12 comments
-
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:
Resources
| where type =~ 'Microsoft.Compute/virtualMachines'
| project name, location, resourceGroup, properties.hardwareProfile.vmSize, properties.storageProfile.osDisk.osType,properties.extended.instanceView.powerState.displayStatusAlso in the following articles you can find other examples:
https://docs.microsoft.com/en-us/azure/governance/resource-graph/samples/advanced?tabs=azure-cli#join-vmpipFrom 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. -
Herbert
commented
a standard GUI export function is important for admin purpose.. but it was missing for a long time
-
RA
commented
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.
-
Tim
commented
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.
-
Prabby
commented
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.
<a href="https://www.devopsonlinehub.com/azure-admin-online-training.html"> -
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?
-
Herbert
commented
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.