• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3444
  • Last Modified:

VMware datastore reports: how to generate?

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?
2 Solutions
Nagendra Pratap SinghCommented:
Do you have powercli installed?

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

Powercli method is discussed below


Danny McDanielClinical Systems AnalystCommented:
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.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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
waltforbesAuthor Commented:
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.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now