rendered paste body
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)