[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2014-07-11
Medium Priority
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 124

Accepted Solution

Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 40190564
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

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A look into Log Analysis and Effective Critical Alerting.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…

834 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