Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Mass edit Node name

sja

We have 200-300 node that the name format need to be change from " IP address + customer name"

to "IP address+ circuit id +customer name"

What is the best way to fix that (just not one at the time :-))

Find more posts tagged with

Accepted answers

All comments

zackm

One of my favorite SQL Procs

First, you create a PROC in SQL Server Management Studio:

CREATE PROC Update_CaptionAS@Caption nvarchar (50),@Ip_Address nvarchar (50)  AS  Update   Nodes  Set   Caption = @Caption  Where   IP_Address = @Ip_Address

Then you run the procedure as follows:

EXEC Update_Caption 'newhostname','xxx.xxx.xxx.xxx'

ie; if you wanted to change this: 10.1.1.1+CustomerName

to this: 10.1.1.1+12345+CustomerName

you would run this:

EXEC Update_Caption '10.1.1.1+12345+CustomerName','10.1.1.1'

The 'newhostname' field can be whatever hostname you want to change to; but the 'xxx.xxx.xxx.xxx' field MUST be the IP Address that the node is currently being monitored on

FYI - You could just as easily run this PROC against other fields like the NodeID; but for us, the IP Address is better as we extract info from our CMDB

Enjoy

njoylif

challenge is tying the info together if in separate tables...do you have a DB table with the circuit IDs in them.

Ideally, if you have them as a custom property in SW, its fairly easy.

let me know where that info resides.

you have to have some UNIQUE field like nodeID or IP Address in each table if in separate so when the two match, you know they are referring to the same node.

sja

Thanks

I just not big on DB or SQL :-)

I just had hope for there was away to export that data to csc/exel and inport it igen with the right format.

I was sure it was possible not long ago :-)