neteng-050:~ # mysql --user=root --password=`cat /etc/odapw` -D oscar -e "select Nics.ifname, Nics.name, Nics.mac from Nics inner join Nodes on Nics.node_id=Nodes.id where (Nodes.name='r1lead' or Nodes.hostname='r1lead')"
+------------+------------+-------------------+
| ifname     | name       | mac               |
+------------+------------+-------------------+
| r1lead-bmc | bmc0       | 00:25:90:9e:97:72 |
| r1lead     | enp129s0f0 | 00:25:90:96:4e:ac |
| NULL       | enp129s0f1 | 00:25:90:96:4e:ad |
| lead-eth   | enp129s0f0 | 00:25:90:96:4e:ac |
| lead-bmc   | enp129s0f0 | 00:25:90:96:4e:ac |
| r1lead-ib0 | ib0        |                   |
| r1lead-ib1 | ib1        |                   |
+------------+------------+-------------------+