Unsolved
This post is more than 5 years old
41 Posts
0
150728
February 13th, 2013 07:00
Dashboard/report to get VMs stored in each datastores
Hi,
I am using vFoglight 6.7. I am trying to have a report generated every week which contains No of VMs running in each datastore. please share with me if anybody had done this before to generate such reports using queries.
No Events found!
DELL-Thomas B
171 Posts
1
February 13th, 2013 12:00
I don't see a way to do it via UI Query as when you take the entire datastores object group you can't then use the UI query. The only way would be a quick WCF dashboard that grabs the datastores and then leverages a query to get the VM count on that store.
raghavendra.ts
41 Posts
0
February 14th, 2013 05:00
Thanks Thomas. Could you please explain it in detail how the query should be written to get the VM count on WCF dashboard. I am very poor in writing query
DELL-Thomas B
171 Posts
1
February 14th, 2013 18:00
Here is an example of the WVF query that takes a datastore and returns a count. You could then use this in a WCF table or what not to get your datastores with VM counts.
raghavendra.ts
41 Posts
0
February 19th, 2013 05:00
Thank you Sir. Let me try this and get back to you with the result.
raghavendra.ts
41 Posts
0
February 22nd, 2013 09:00
Hi, As you guided, the query has been created and I can view the VM counts when I select the datastore name in the query. I am finding difficulties in creating a view for the same to list the VM count for all the datastores we have. This query is not allowing me to create columns in the view.
request you to share any usefull documents on creating custom views for these type of queries. I am not getting how the view has to be created to get the VM count for all the datastores. I always think how the queries actually works in vfoglight, I am very poor in writing queris:(
Once again I greatly appreciate your kind help on preparing this list.