How can we improve Azure Virtual Machines?

← Virtual Machines

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

119 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Aquib Qureshi shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
triaged  ·  Adminazurecxpuservoice (Product Manager, Microsoft Azure) responded  · 

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.

13 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Bogdan Troncea commented  ·   ·  Flag as inappropriate

    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.displayStatus

    Also 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-vmpip

    From here you can export to CSV

  • Khaleel, Rahman (ITS) commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    a standard GUI export function is important for admin purpose.. but it was missing for a long time

  • RA commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Aquib Qureshi commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Virtual Machines

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice