How can I find all virtual servers and their owners' email addresses currently assigned to a particular compute resource?
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:
- Find the
hypervisor_idof the compute resource on the OnApp database:
SELECT id, label, ip_address FROM hypervisors;
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;