Can we pull report of esxi enviorment.
Report should state :
No. of host in cluster
No. of VMs.
CPU and Memory ratio of host and virtual mahine.
how much memory is utilised and how much is free in a cluster.
Have a look at vCheck, it has everything you need and is built up on modules so you can simply pick the ones you want;
I would agree vcheck would provide everything you want and can output to csv. If you want to do something manual then you might want to check my power cli basic blog links:
No. of host in cluster - Can be found using the math in my blog entries
No. of VMs. - Also can be found using math in blog entry with get-vm
CPU and Memory ratio of host and virtual mahine. - Listed in my blog entry
how much memory is utilised and how much is free in a cluster. - This can be a bit hard but you can use the math in my blog post as well.
I will again say that if you can use vcheck I would do it... a much better product.
Consider assigning points for helpful answers to jrmunday and I...
Let us know if you have additional questions.
You should use some VMware performance monitoring tools for checking all performance details of your esxi or VMware environment. I am using MindArray IPM's Vmware monitoring tools for improving performance of esxi network as well as to check detailed report about performance of esxi environment.