VMware datastore reports: how to generate?

Posted on 2012-08-12
Last Modified: 2012-08-13
Points of My Scenario:
1. I am vsphere admin for100+ virtual machines.
2. I need to provide management an Excel report on datastore usage (size & free space)
How can I generate an Excel report on datastore usage?
Question by:waltforbes
    LVL 23

    Expert Comment

    by:Nagendra Pratap Singh
    Do you have powercli installed?

    Else you can export to webpage and then import and clean it up.

    Powercli method is discussed below
    LVL 16

    Assisted Solution

    If you have vcenter server, go to Datastores view (ctrl-shift-d), click on an upper level like the datacenter or folder, then click on Datastores and Datastore clusters tab, and finally click on some white space in the list and choose Export List.  You can change from html to csv or some other file type.  Might work from datastores list w/out vcenter server, but haven't tried it out.
    LVL 116

    Accepted Solution

    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

    You could also use RVTool

    Author Closing Comment

    To danm66: your solution is so simple and gives exactly what I was looking for.
    To hanccocka: RVTool is a super tool that is both simple to use and provides what I need and so much more.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    VMware vCenter Converter Standalone 5.0 is a FREE tool available from VMware upon registration, the purpose of this software tool is to easily convert physical or virtual computers, images of computers to VMware virtual machines. Server and Workstat…
    One of the new features of a version 7.0 or later virtual machine, supported in VMware vSphere 4.1, 5.0 or the VMware vSphere Hypervisor ESXi 4.1, ESXi 5.0 often overlooked by VMware Administrators is the ability to add and connect USB devices conne…
    Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
    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…

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now