Something

opennms=# select * from snmpinterface where nodeid=805;
  id  | nodeid |    ipaddr    | snmpipadentnetmask | snmpphysaddr | snmpifindex | snmpifdescr | snmpiftype | snmpifname | snmpifspeed | snmpifadminstatus | snmpifoperstatus | snmpifalias 
------+--------+--------------+--------------------+--------------+-------------+-------------+------------+------------+-------------+-------------------+------------------+-------------
 6142 |    805 | 10.40.105.17 |                    |              |        -100 |             |            |            |             |                   |                  | 
(1 row)