This post is more than 5 years old
1 Message
0
756
February 16th, 2011 11:00
How to create the meaningful report for VM machines in StorageScope?
Hello Ionix gurus.
I am trying to create the meaningfull report that lists following information:
On a per VM basis we want:
-Provisioned Storage
-Used Storage
For every partition in VMsVMDK files we want:
-Drive letter
-Partition size
-Used space
-free space
I am planning to assign the custom field mapping the VMs VMDK file to application for the Chargeback reports.
I was trying different queries but no luck. I can get the provisioned storage but not "used" for VM and even less for VMDK
We do use thin provisioning on VMWare
Is anyone ever tried to create the similar report?
Deeply appreciate for the ideas
Rada
No Events found!
AnuShivnath
41 Posts
0
February 16th, 2011 12:00
To find out provisioned storage and used storage for a ESX Server, in STS QB,
a) Create a new query
b) Pick "ESX Server" as the Area of Interest.
c) Pick Column ESX Server. Acessible -Array(Provisioned Capacity)
d) Pick Column ESX Server.VMFS Capacity and ESX Server.Raw/RDM. The sum of these two should provide the ESX Server used capacity.
To find out the Partition Size of each VMDK file
a) Create a new query
b) Pick "ESX Server" and "VM File" as the Area of Interest.
c) Select the columns VM file.VM FileCapacity (this should be the partition space).
It may be possible to get Used and Free space at the level of VMFS by linking in "FileSystems" and "VM Machine" in the "Area of Interest" while creating a query. The Used capacity for the VMFS would be the sum of VM MAchine.FileSystem Total + VM Machine.Raw Database Total. For this, the VM Machine should be discovered with a host agent..