• 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)
QUESTION:
How can I generate an Excel report on datastore usage?
0
waltforbes
Asked:
waltforbes
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

http://vsential.com/2010/09/datastore-size-reporting-via-powercli-script/


http://communities.vmware.com/thread/339826
0
 
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.
0
 
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.

http://communities.vmware.com/community/vmtn/server/vsphere/automationtools/powercli

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

http://powergui.org/index.jspa

and

VMware Community Pack
http://www.virtu-al.net/featured-scripts/vmware-powerpack/

You could also use RVTool
http://www.robware.net/
0
 
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.
0

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