This post is more than 5 years old
41 Posts
0
142194
August 30th, 2012 12:00
Report on No of VMs per datastore
Hi,
I am using vFoglight 6.6.2. I am trying to have a report generated every week which contains No of VMs running in datastore. But I dont know how to create a dashboard/report to get these details.
requesting experts assistance.
No Events found!



hdoubleu
19 Posts
0
September 10th, 2012 10:00
Following query gives you as a result all virtual machines on the specified datastore
Using the following required input parameters:
{VMWDatastore} : of type foglight-5:VMWDatastore
Select objects of type VMware Virtual Machine from parameter {VMWDatastore}
from Root of {VMWDatastore}/virtualCenter/virtualMachineCollection/virtualMachines
where:
({VMWDatastore} in /datastores And
/vmState/current/value equals "poweredOn")
Setup as UI query will let you use this as a dashboard input.
Try around with the query and let me know if this help.
Best regards,
hEINER
raghavendra.ts
41 Posts
0
February 6th, 2013 10:00
Thanks for sharing it. My bad, I am not getting exactly how to create this query. I am confused how to put the where: And condition with the query you posted under UI query. I request you to brief it since I am new to write queries in vFoglight.
Thanks again.