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.

0 Comments

Please sign in to leave a comment.