-
Re: node name change
denny.lecompte Jul 1, 2009 10:58 AM (in response to awazir)That was a known bug, and we thought it was fixed in all cases. Could you open a Support ticket to that we can look at it in more detail?
-
Re: node name change
menz Jul 8, 2009 10:22 AM (in response to denny.lecompte)Did this get fixed as i face the same issue on 9.5 sp2
sam
-
Re: node name change
bshoppJul 8, 2009 10:27 AM (in response to menz)
SP2 is the current service pack that has been released, so this is still an open issue
-
-
-
Re: node name change
cstaniforth Jul 10, 2009 9:40 AM (in response to awazir)Id just bite the bullet and manually update them!
-
Re: node name change
amprantino Jul 15, 2009 2:37 AM (in response to cstaniforth)I changed around 100 node names, and after running "rediscovery" for allnodes the name in NPM remains the same!
I cant delete all nodes and readd them!
Any idea if this can solved? Any workaround?
I am using Orion NPM 9.5 SP1.
Thank you
-
Re: node name change
bshoppJul 15, 2009 10:28 AM (in response to amprantino)
Until we release the fix, only workaround is to manually update them
-
Re: node name change
jcooler Jul 15, 2009 10:40 AM (in response to bshopp)If you are just wanting to update the node name with the "system name", you can write a SQL update script to do that quick and easy. I'll post the SQL code if anyone is interested.
-
Re: node name change
Chandru Jul 20, 2009 2:48 AM (in response to bshopp)Hi,
Is this planned for the next SP or a hot fix will be released soon
Chandru
-
Re: node name change
DonC72 Aug 6, 2009 10:41 AM (in response to Chandru)Hello. Has any ground been made on this? I'm at the point where I have to basically delete all "old" nodes with the old nomenclature and have to rediscover them, which wipes out all reporting and historical data. I know I can easily rename the nodes via Atlas, but that will lead to confusion with reporting, won't it?
Thanks!
-
Re: node name change
bshoppAug 6, 2009 10:50 AM (in response to DonC72)
jcooler, can you post your SQL script as a workaround till we get this issue resolved so Don does not have to delete his nodes
-
Re: node name change
DonC72 Aug 6, 2009 10:57 AM (in response to bshopp)I'm not much of an SQL whiz. Is this pretty straightforward? On a scale from 1-5, 5 being most knowledgeable, I'd be a -1 regarding SQL "how to"
-
Re: node name change
jcooler Aug 6, 2009 11:45 AM (in response to DonC72)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.
-
Re: node name change
DonC72 Aug 6, 2009 12:23 PM (in response to jcooler)Yes, that would be very helpful, I just took at look thru our custom property editor, and a rather large amount of the names do pull the domain name, which would further complicate this.
As a side, is it possible to test it on a select few first as opposed to popping that in there and doing everything in one fell swoop?-
Re: node name change
jcooler Aug 6, 2009 1:05 PM (in response to DonC72)1 of 1 people found this helpfulTo test on a few nodes, add a where statement to the end of the script similar to what you see below.
As for the domain names, here is a good start. It will have to be customized a little to match your domain name(s). Simply add or delete the WHEN/THEN statements as needed. You will need a WHEN/THEN for each domain name you use.
UPDATE Nodes
SET caption = (
SELECT RTRIM( SUBSTRING(
sysName, 1,( (
Select CASE
WHEN (CharIndex ('.domain1.com', sysName) > 0)
THEN (CharIndex ('.domain1.com', sysName)-1)
WHEN (CharIndex ('.domain2.com', sysName) > 0)
THEN (CharIndex ('.domain2.com', sysName)-1)
WHEN (CharIndex ('.domain3.com', sysName) > 0)
THEN (CharIndex ('.domain3.com', sysName)-1)
ELSE (LEN(sysName))
END ) )
)
)
)
Where (IP_Address= 'xxx.xxx.xxx.xxx') AND (IP_Address= 'yyy.yyy.yyy.yyy')--Replace domain#.com with your domain name.
--Replace xxx.xxx.xxx.xxx and yyy.yyy.yyy.yyy with your test node IPs.
To expand your test group, add more ips to the where statement in the format of" AND (IP_Address= 'yyy.yyy.yyy.yyy') "
You could also use any other field in the WHERE statement. Like city = 'Greenville' or location = 'closet 4' or what ever you like.
You dont have to worry as much about messing something up if you limit it with the WHERE statement.
Hope this helps. Feel free to ask more questions if they arise.
-
Re: node name change
DonC72 Aug 6, 2009 2:41 PM (in response to jcooler)Thanks, I will give it a try.
-
-
-
Re: node name change
brian_crypto Aug 25, 2009 7:19 AM (in response to jcooler)1 of 1 people found this helpfulI cam across this looking for similar function ... I think it is a little better in that it removes nodes without a SysName, useful if you have ICMP only nodes and don't want the update making their captions all NULL.
Query to display nodes where caption and SysName don't match:
SELECT Caption, SysName, IP_Address FROM Nodes
WHERE ((Caption <> SysName) AND (SysName <> ''))
ORDER BY CaptionCommand to update the nodes:
UPDATE Nodes
SET Caption = SysName
WHERE Caption in (SELECT Caption FROM Nodes WHERE ((Nodes.Caption <> Nodes.SysName) AND (Nodes.SysName <> '')))-
Re: node name change
DonC72 Sep 1, 2009 1:18 PM (in response to brian_crypto)Thanks. I am still holding off. I was reading thru the SP4 release hoping it would be addressed, and still not. I hate losing the data, but we are just rediscovering everything that we change. I can't beleive something like this is not important enough to have made it to a service pack. I'd much rather right click and select rediscover and have that kick off the sysname discovery, but I guess I'll wait for another SP or 2.
-
-
Re: node name change
DonC72 Sep 4, 2009 11:53 AM (in response to amprantino)Are you speaking of this fix?
Changes to interface names are now correctly discovered by web node management.
I will certainly test it. I am guessing this means that via the web interface, do we rediscover or poll a device for this to be fixed? We're not only renaming all devices, but setting up advanced alerts via key words, so anything that did not have "uplink" or "MPLS" listed, we are going to have to change. I have to follow up on Tuesday. I sure hope it does work.
-
Re: node name change
amprantino Sep 6, 2009 8:21 AM (in response to DonC72)I will try to update the server during the week, and see if it works!
-
Re: node name change
isaac.smith Oct 27, 2009 2:26 PM (in response to amprantino)Any update to this? I don't know much about SQL and would rather not screw something up on our DB
-
Re: node name change
DonC72 Oct 30, 2009 10:59 AM (in response to isaac.smith)I hear that. So, yea, the SQL fix will absolultely not work for us. I'd wish it would be added as a simple right click menu, but no go. So, I had to redo all switch names and interfaces, as that does not work either. Very annoying that the work around has to be a home grown and not company provided.
-
Re: node name change
isaac.smith Oct 30, 2009 11:08 AM (in response to DonC72)Yeah I did the SQL script via Report Writer and it worked on my test router just fine. I was going to schedule it via Report Scheduler for weekly updates, but contacted our Database Admins and they were able to create the script and schedule it themselves.
-
Re: node name change
bedwards1216 Nov 9, 2009 10:09 AM (in response to isaac.smith)Is there any update from SW on this issue? Is this going to be addressed in a future service pack? If so, any idea when?
While the "Verified answer" in this thread is an OK and adequate workaround, it's hardly a "solution". The problem remains and needs to be addressed.
-
Re: node name change
bshoppNov 9, 2009 10:43 AM (in response to bedwards1216)
This is still an open item in our system. Unfortunantly I cannot give any time frame on resolution
-
Re: node name change
bedwards1216 Aug 30, 2010 10:48 AM (in response to bshopp)Version 10, SP1 now out and this issue has still not been resolved... continues to be very frustrating. Is there any update as to when or if this problem will be adderssed? I have hundreds of devices with the correct naming convention that Orion has not updated to the correct device name.
-
Re: node name change
chris.lapoint Aug 31, 2010 3:58 PM (in response to bedwards1216)Please provide me a case number that you've opened on this issue and I'll check to see where this is at.
-
-
-
-
-
-
-
-
-
-
-
-
Re: node name change
sfp Jul 28, 2017 3:18 AM (in response to jcooler)As pointed by @sedmo (Re: How to get Orion to update the node name from the hostname ) there can be some exceptions to be handled, for example empty sysName (say misconfigured device or device monitored with ICMP where SolarWinds don't have sysName value).
-
-
-
-
-
-
-
-
-
Re: node name change
DonC72 Jul 15, 2009 10:58 AM (in response to awazir)I had to do the same for our MPLS rollouts & renames - I had to remove the old and rediscover unfortunately. I'll be following this one. I have many more to do, hopefully there is a way.
-
Re: node name change
sedmo Jul 15, 2009 11:22 AM (in response to awazir)You might check this thread and see if it is useful.
Re: How to get Orion to update the node name from the hostname
-
Re: node name change
DonC72 Jul 15, 2009 11:26 AM (in response to sedmo)Thanks! I did see that earlier, but was hoping it was fixed in the latest version. I did open a ticket a while back and beleive it was closed as I am fairly certain that it was supposed to be in this version per the notes. I'd rather not have to do the queries, but can as a last resort.
Thanks
-
-
Re: node name change
rawwinton Jun 21, 2015 10:25 PM (in response to awazir)How do u allow it to run without having to manually cancel the process?
the update statement had been executed but the report manager will show "querying database" without exiting