Retrieve list of all VMs up longer than 24 hours

find_nodes.py

from datetime import datetime

NOW = datetime.utcnow()

import os_client_config
import prettytable
import shade

cloud_config = os_client_config.OpenStackConfig().get_all_clouds()
for config in cloud_config:
    pt = prettytable.PrettyTable(['ID', 'Name', 'Status', 'Uptime'], caching=False)
    pt.align = 'l'

    print config.name

    cloud = shade.openstack_cloud(cloud=config.name)
    servers = cloud.list_servers()

    for s in servers:
        created = datetime.strptime(s.created, "%Y-%m-%dT%H:%M:%SZ")
        uptime = NOW - created

        if uptime.days < 1:
            continue

        pt.add_row([s.id, s.name, s.status, uptime])

    print pt
    print