VMWARE Vsphere - Generating a report on VM's and their IP addresses

Posted on 2014-07-11
Last Modified: 2014-07-15
I have a group of VM's and I'd like to generate a report on their names, IP addresses, etc.
Can someone give me an idiot-proof step-by step to generate this report?
Currently I'm manually going through the Vsphere screen writing down each IP address as I click on each VM.
Example:  I want the name of every SQL server VM and its related attributes  IP address, etc. (See diagram).
Question by:brothertruffle880
    1 Comment
    LVL 116

    Accepted Solution

    A few ways to do this, RV Tools from here is a great tool

    or, you can use the vSphere Client Virtual Machines Tab, Right Click select the fields you require e.g IP Address and then Export the current list to Web Page, CSV or XLS, Right Click the Bottom Drag box, and select Export.

    or you can script it, or use the tools from here

    I would recommend using the following, also VMware recommends the use of PowerCLI, which is PowerShell interface with vSphere-specific additions.

    One of the simplest PowerCLI examples, and something which is actually extremely useful on its own, is the Get-VM cmdlet. Which lists VMs.

    PowerCLI can be a bit overwhelming to use,  But it can be enhanced with a nice toolset and a library of preconfigured scripts to jump-start your mass changes, which is possible with PowerGUI


    VMware Community Pack

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    This Tutorial covers a very basic and common question asked on Experts Exchange, "How Do I Clone or Copy a virtual machine in VMware vSphere Hypervisor ESX/ESXi 4.x, ESXi 5.0?" Using the following method, no third party tools are required or need…
    After we apply, or update, ESXi 5.5 we can get this warning in ESXi host: No coredump target has been configured. Host core dumps cannot be saved
    This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now