Helpful VKernel SearchMyVM queries for use in VI3 environments

In my opinion, VKernel’s SearchMyVM virtual appliance (VA) has to be one of the most useful free virtualization management tools. I have found myself using it quite frequently to get information about my environment. I mentioned its release over on SearchServerVirtualization, and here I want to share some common queries I’ve used that you may want to hold onto for frequent use, and how they can help you:

vm.cdroms.connected=true – Running this query will tell you which VMs have connected virtual optical media, which can inhibit VMotion on the guest.

vm.toolsStatus=toolsNotInstalled,toolsNotRunning,toolsOld – All VMs that have VMware tools status of everything but OK.

cluster.haFailoverLevel – Lists all cluster’s HA Failover level. This is an easy way to spot check for consistent settings.

cluster.drsEnabled – Shows clusters that have DRS enabled. This one goes hand and hand with the HA settings to ensure that they are enabled across all environments as expected.

vm.hostName:servername – Gives the quick query of a guest’s hostname that is like servername, this is incredibly handy if you need to quickly find what resource pool, cluster, or datacenter a virtual machine is located.

 from the VKernel website.