opennms=# select * from node where nodeid=2;
 nodeid |  dpname   |       nodecreatetime       | nodeparentid | nodetype | nodesysoid | nodesysname | nodesysdescription | nodesyslocation | nodesyscontact | nodelabel  | nodelabelsource | nodenetbiosname | nodedomainname | operatingsystem |       lastcapsdpoll        | foreignsource | foreignid
--------+-----------+----------------------------+--------------+----------+------------+-------------+--------------------+-----------------+----------------+------------+-----------------+-----------------+----------------+-----------------+----------------------------+---------------+-----------
      2 | localhost | 2008-10-29 12:40:53.655+00 |              | A        |            |             |                    |                 |                | 10.2.0.254 | A               |                 |                |                 | 2008-10-30 20:22:43.219+00 |