Question: I want to identify virtual machines which are powered off. What query can I run which will return the full list of virtual machines within a VMWare vCenter database where the power state = OFF. Answer: It is possible to return the recordset by querying the database. Find a sample query executed on a vcDB database. The query includes some extra information , which you may find useful . The key column is the POWER_STATE column in the vpxv_vms table. There are different potential power states for a virtual machine . Possible values are off, on, and suspend SELECT... Read more →