How can I find all VMs and their owners' e-mail addresses currently assigned to a particular hypervisor?
***Please see this article for additional details about working with the OnApp database***
Find the hypervisor_id of the HV in the OnApp database:
SELECT id, label, ip_address FROM hypervisors;
Replace 'xxx' with the hypervisor_id in the following query:
SELECT label, email FROM virtual_machines v INNER JOIN users u ON v.user_id =u.id WHERE hypervisor_id = xxx;