Opennms change node label
Opennms change node label
And use psql
postgres=# \c opennms;
You are now connected to database "opennms" as user "postgres".
opennms=# BEGIN;
BEGIN
opennms=# UPDATE node SET nodelabelsource= 'U', nodelabel = 'WG-WS2012-W-16.cloudapp.net' WHERE nodeid = 31;
UPDATE 1
opennms=# COMMIT;
COMMIT
opennms=# COMMIT;
WARNING: there is no transaction in progress
COMMIT
opennms=# \q