MySQL. List All Virtual Servers and Associated User Email Addresses for a Compute Resource

Question

How can I find all virtual servers and their owners' email addresses currently assigned to a particular compute resource?

Environment

Any OnApp

Answer

Please refer to the Access the MySQL Database in OnApp page for additional details about working with the OnApp database.

To list all virtual servers and their owners' e-mail addresses assigned to a particular compute resource:

1. Find the hypervisor_id of the compute resource on the OnApp database:

SELECT id, label, ip_address FROM hypervisors;

       2. Replace xxx with the desired 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;