Open Stack

Hey guys, 
many asked me for that, here is the small sql query :
> select concat("/var/lib/nova/instance/instance-00000",conv(id, 10, 16),"/") as instance_path,power_state,vm_state,display_name from instances where deleted=0 and host="vs11" order by id


It'll give you the according directory :)


regards,
Razique



Razique Mahroua - Nuage & Co
razique.mahroua at gmail.com
Tel : +33 9 72 37 94 15



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20130712/e80aee5a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: NUAGECO-LOGO-Fblan_petit.jpg
Type: image/jpeg
Size: 10122 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20130712/e80aee5a/attachment.jpg>