rendered paste bodyopennms=# select * from node n join ipinterface ip on ip.nodeid = n.nodeid where ip.ipaddr = '10.252.4.254';
nodeid | dpname | nodecreatetime | nodeparentid | nodetype | nodesysoid | nodesysname | nodesysdescription | nodesyslocation | nodesyscontact | nodelabel | nodelabelsource | nodenetbiosname | nodedomainname | operatingsystem | lastcapsdpoll | foreignsource | foreignid | id | nodeid | ipaddr | ifindex | iphostname | ismanaged | ipstatus | iplastcapsdpoll | issnmpprimary | snmpinterfaceid
--------+-----------+-------------------------+--------------+----------+------------+-------------+--------------------+-----------------+----------------+-----------------------+-----------------+-----------------+----------------+-----------------+-------------------------+---------------+-----------+-------+--------+--------------+---------+-----------------------+-----------+----------+-------------------------+---------------+-----------------
1333 | localhost | 2007-07-12 14:19:26.045 | | A | | | | | | claren.remotelabs.com | H | | | | 2007-07-12 14:19:26.045 | | | 16164 | 1333 | 10.252.4.254 | -100 | claren.remotelabs.com | M | | 2007-07-12 14:19:26.133 | P | 16165
1332 | localhost | 2007-07-12 10:04:30.674 | | D | | | | | | claren.remotelabs.com | H | | | | 2007-07-12 10:04:30.674 | | | 16159 | 1332 | 10.252.4.254 | | claren.remotelabs.com | D | | 2007-07-12 10:04:30.778 | N |
(2 rows)
opennms=#