cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Bulk Node Name/Caption Change

I've seen this needed a few times here and with various clients so I find a spreadsheet similar to this comes in handy.

This spreadsheet can be used to create the SQL update queries to bulk update node names in the SolarWinds database.

Note: This query will only work on the newer Orion database structure (NPM 11.5+, SAM 6.2+, NCM 7.4+) as it references the 'NodesData' table. For older versions, change the table to 'Nodes'.

1. Get a list of the node captions and IP addresses that you need to update as two columns. There are a few ways to do this but try one of the below:

- Generate a report in the report writer - select the caption/nodename and IP address fields.

- Run a SQL query on the database (Using either SQL Management Studio or Database Manager on the SolarWinds server).

SELECT Caption, IP_Address FROM [dbo].[Nodes]

- Once you have your list, update the list with your new captions as well as any new IP addresses.

2. If you need to import these nodes into SolarWinds, run a discovery and import all of the nodes using the IP address list (manually add the nodes that don't respond as the discovery will only find your up nodes).

3. Use the attached spreadsheet to generate the SQL queries that you can use to update the database with the desired names (matching on IP address). Paste the captions and IP addresses into columns A and B. Column D contains the SQL queries.

4. Backup your SolarWinds database.

5. Paste the queries back into SQL Management Studio or Database Manager and execute to update the node names. E.g.

UPDATE NodesData SET Caption = 'Fred' WHERE IP_Address = '1.2.3.4'

UPDATE NodesData SET Caption = 'Testname' WHERE IP_Address = '1.1.1.1'

Hope this helps!

Steve

Labels (2)
Attachments
Comments

Works like a charm, no fallout.

Giving this a try.

This worked great.  Also used the spreadsheet concept to correct the AD group permissions across our solarwinds servers in different markets.

Awesome. Very helpful!

This was a very good
Time Consuming Time Saving find within the THWACK Community.

Thank you for posting the Spreadsheet with the SWQL Syntax to be able standardize the Node Names.

By looking in to this further I was disappointed to find that we can’t currently apply a similar SWQL Syntax to changing the Custom Properties of a Node Group.

You can only use one navigation property in a single expression.

This prevents you from doing something like I.Node.CustomProperties.City because Node and CustomProperties are both navigation properties.

https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/How_to_use_SolarWind...

Or is there anywhere we can add the Custom Properties within the SWQL Query Database to change the Custom Properties by executing a SWQL Script?

And not have to do it with the CUSTOM PROPERTY EDITOR, EDIT PROPERTIES or any other method for each Node within a group individually or a smaller group within the main group of Nodes that the change is applicable to?

Spotted this after I'd asked a similar query - this does the job wonderfully for this d/b inept bod

Thanks.

This worked perfectly, thanks for sharing!

How is this not baked into the custom importer provided it even has the values to match with but sadly cant import to them. SW Devs please let us import and force values everywhere.

Can someone please link the create script for the NodesData table for NPM 2019.4 HF2?  Long story short, i used a csv file and a batch update to change the caption on a few thousand nodes and I kept the copy of the table that doesn't have any of the constraints/keys on it.  I didn't realize it until after I already closed the create script I had open in SQL Management Studio...   😔   Now I'm getting errors when I try to import new nodes.

Version history
Revision #:
1 of 1
Last update:
‎09-07-2015 11:10 PM
Updated by: