get_host.py

#!/usr/bin/python
"""Get ips from nova hosts. Quick and dirty.
"""
from re import findall
from subprocess import check_output
from shlex import split
from json import dumps

def sh(cmd):
    return check_output(split(cmd))

print(dumps(
    dict(databases=
      dict(hosts=
       findall(r'\b(192.168.\d+.\d+)\b', sh('openstack server list --format=csv'))
     )
   )

))