Miscellany

opennms=# select * from node where nodeid = 59;
 nodeid |  dpname   |     nodecreatetime      | nodeparentid | nodetype | nodesysoid | nodesysname | nodesysdescription | nodesyslocation | nodesyscontact |      nodelabel      | nodelabelsource | nodenetbiosname | nodedomainname | operatingsystem |      lastcapsdpoll
--------+-----------+-------------------------+--------------+----------+------------+-------------+--------------------+-----------------+----------------+---------------------+-----------------+-----------------+----------------+-----------------+-------------------------
     59 | localhost | 2005-04-08 04:47:04.462 |              | A        |            |             |                    |                 |                | staros-wharfrd.wifi | H               |                 |                |                 | 2005-05-17 14:32:59.211
(1 row)