opennms=# select * from ipinterface where nodeid=59;
 nodeid |    ipaddr    | ifindex |     iphostname      | ismanaged | ipstatus |     iplastcapsdpoll     | issnmpprimary
--------+--------------+---------+---------------------+-----------+----------+-------------------------+---------------
     59 | 0.0.0.0      |       5 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |       6 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |       7 |                     | U         |        1 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |       8 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |       9 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |      10 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |      11 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 0.0.0.0      |      12 |                     | U         |        2 | 2005-04-08 04:47:04.485 | N
     59 | 10.0.59.100  |       4 | staros-wharfrd.wifi | M         |        1 | 2005-05-17 10:36:48.295 | P
     59 | 10.255.255.2 |       2 | staros-wharfrd.wifi | M         |        1 | 2005-05-17 10:36:48.295 | S
     59 | 192.168.1.1  |       3 | 192.168.1.1         | M         |        2 | 2005-05-17 10:36:48.295 | N
(11 rows)