node name change

Question

i am running Orion NPM 9.5 SP2. I am just tasked with changing node names for 100s od devices. The current names are not very logical. Once the device name is changed, i see that the sys-name is updated via snmp but the "node name" does not change. I read somewhere that if I just delete the nade name, the system will update it from sys-name. It did not work. Once tried, now the device shows up with a blank name ...just a green dot. Con someone help?

BTW: I have had nothing but trouble since moving to 9.5. I dont believe this version was ready for release....heard SP3 is coming out in July....

jcooler · Accepted Answer

Here is sql script that will change the Nodes.caption field to match the Nodes.sysName field. The Nodes.caption is the node name that you see on the node list, maps, node details etc. The Nodes.sysName is the system name extracted from snmp.  It is the "System Name" displayed under the node details sections. This script can be executed in Report Writer application(easiest), the SQL Management Studio, and probably Orion's Database Manager(I haven't tried it here) .  --Note: If you execute it in Report Writer, it will not show that the query completes, because it is looking for some data to be returned, but it does actually complete the script. Simply execute it, let it run for a minute or so, then hit cancel. So, here's the script: --------------------------------------- UPDATE Nodes     SET caption =(select  sysname) --------------------------------------- Thats it. Just 2 lines. This will set every node name to the system name. If you are interested removing the domain names from the nodes, I have a script for that too. Just let me know.

node name change

Top Replies