Skip to main content

MySQL - Find all VMs using the same data store

  • Updated
We moved this page to our Documentation Portal. You can find the latest updates here.

Question

How can I find all VMs using the same data store?

 

Environment

All versions of 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 all VMs using a specific data_store (replace xx with the desired data_store_id:

SELECT v.label, v.id, v.hypervisor_id, d.data_store_id FROM virtual_machines v JOIN disks d ON v.id = d.virtual_machine_id JOIN data_stores s ON s.id = d.data_store_id WHERE d.data_store_id = xx;