[Openstack-operators] Quick type : find the instance directory by instance id

Razique Mahroua razique.mahroua at nuage-and-co.fr
Fri Jul 12 14:11:27 UTC 2013

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 :)


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>

More information about the OpenStack-operators mailing list