opennms=# select * from snmpinterface where nodeid ='17';
 nodeid |    ipaddr    | snmpipadentnetmask | snmpphysaddr | snmpifindex | snmpifdescr | snmpiftype | snmpifname | snmpifspeed | snmpifadminstatus | snmpifoperstatus
--------+--------------+--------------------+--------------+-------------+-------------+------------+------------+-------------+-------------------+------------------
     17 | 67.43.47.214 |                    |              |           2 |             |            |            |             |                   |
     17 | 67.43.47.242 | 255.255.255.255    |              |           5 | dummy1      |          6 |            |    10000000 |                 1 |                1
     17 | 67.43.47.241 | 255.255.255.255    |              |           4 | dummy0      |          6 |            |    10000000 |                 1 |                1
     17 | 0.0.0.0      |                    | 0004ac66eca5 |           3 | eth1        |          6 |            |   100000000 |                 1 |                1
     17 | 10.255.2.1   | 255.255.255.252    | 000f20376270 |           2 | eth0        |          6 |            |    10000000 |                 1 |                1
(5 rows)

opennms=# select * from ipinterface where nodeid ='17';
 nodeid |    ipaddr    | ifindex |       iphostname        | ismanaged | ipstatus |     iplastcapsdpoll     | issnmpprimary
--------+--------------+---------+-------------------------+-----------+----------+-------------------------+---------------
     17 | 67.43.47.214 |       2 | cr1nescmm3.crownfin.com | M         |        1 | 2005-01-20 16:04:10.483 | P
     17 | 0.0.0.0      |       3 |                         | U         |        1 | 2005-01-20 16:04:10.483 | N
     17 | 67.43.47.242 |       5 | 67.43.47.242            | M         |        1 | 2005-01-20 16:04:10.483 | S
     17 | 67.43.47.241 |       4 | 67.43.47.241            | M         |        1 | 2005-01-20 16:04:10.483 | S
     17 | 10.255.2.1   |       2 | 10.255.2.1              | N         |        1 | 2005-01-20 16:04:10.483 | N