opennms=> select * from ipinterface where nodeid=79;
 nodeid |     ipaddr     | ifindex |   iphostname   | ismanaged | ipstatus |     iplastcapsdpoll     | issnmpprimary
--------+----------------+---------+----------------+-----------+----------+-------------------------+---------------
     79 | 208.42.129.113 |       2 | 208.42.129.113 | M         |        1 | 2006-12-05 14:45:40.235 | P
     79 | 208.42.129.30  |       1 | 208.42.129.30  | M         |        1 | 2006-12-05 14:45:40.235 | S
     79 | 208.42.129.30  |       1 | 208.42.129.30  | M         |        1 | 2006-12-05 14:45:40.235 | S
(3 rows)

opennms=>