MySQL - List all VMs and associated user email addresses for a given hypervisor

Question

How can I find all VMs and their owners' e-mail addresses currently assigned to a particular hypervisor?

Environment:

Any OnApp

Answer:

***Please see this article for additional details about working with the OnApp database***

https://onapp.zendesk.com/entries/22073502-mysql-how-to-access-the-mysql-database-in-onapp

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;