Hi,
Go to your virtual center client ...>select datacenter---> and then on right side -> select virtual machine tab->right click on that bar and select guest os,esx host ,ip address option from list and uncheck unnecessary option .---->click on guest os tab .u will get the vms with os type...
Get a list of them by exporting list.File-->export->export list.
This is the simplest way,in few click u will get a list distingiushed by os with esx host name/ip.
If you found this or any other answer useful please consider the use of the Helpful or correct
buttons to award points.
thnx.