SQL Query to check if a VM is persistent

version: Abiquo 2.3.X
component: database

At some point you may want to know if a VM is persistent or not. You can perform this mysql query to obtain that information:

select vi.stateful 
from kinton.virtualmachine vm, kinton.virtualimage vi 
where vm.idImage=vi.idImage 
and vm.name='ABQ_uuid';

Output will be:
1 if the VM is persistent. 
0 if it is not.


Please sign in to leave a comment.