Get all BMC IP addresses and which nodes use them from the MAAS database.

get_bmc_ips

#!/bin/bash
cat << EOF | sudo -u postgres psql -P pager=off maasdb 2> /dev/null
    SELECT
        sip.ip "bmc_ip",
        node.hostname AS "machine_hostname",
        bmc.power_type
        FROM maasserver_bmc bmc
            LEFT OUTER JOIN maasserver_staticipaddress sip
                ON sip.id = bmc.ip_address_id
            LEFT OUTER JOIN maasserver_node node
                ON bmc.id = node.bmc_id
        WHERE bmc.ip_address_id IS NOT NULL
        ORDER BY sip.ip;
EOF