opennms=# select nodelabel from node where nodeid=89;
   nodelabel
---------------
 89.250.114.33
(1 row)

opennms=# select * from ifservices where nodeid=89;
 id  | nodeid |    ipaddr     | ifindex | serviceid | lastgood | lastfail |    qualifier     | status | source | notify | ipinterfaceid
-----+--------+---------------+---------+-----------+----------+----------+------------------+--------+--------+--------+---------------
 421 |     89 | 89.250.114.33 |         |         1 |          |          |                  | A      | P      | Y      |           419
 422 |     89 | 89.250.114.33 |         |         8 |          |          | 23               | N      | P      | Y      |           419
(2 rows)