How can I find out users who recently owned a particular floating ip?

asked 2015-05-14 16:48:16 -0500

kjtanaka gravatar image

We have OpenStack Juno with Neutron, and I'm searching the right syntax to ask MySQL which user owned the floating ip 192.168.1.1 recently. The instance and floating ip have already been deleted by the user, so I'm not able to do it by the nova/neutron command line tools. I expected something like below, but it looks not that simple, maybe it's because we have Neutron.

use nova;
select * from instances where floating_ip='192.168.1.1';

Any comment/advise would be highly appreciated. Thanks!

edit retag flag offensive close merge delete

Comments

the neutron server logs

darragh-oreilly gravatar imagedarragh-oreilly ( 2015-05-15 11:53:07 -0500 )edit