I have about 3000 of nodes, I need to rename every one and add info to our custom property´s, then here are my method:
1. Create an excel spreed sheet with all your info like this (the IP address going to be our Key Field):
| IP | State | Site | S_ID | Node | Kind | Phone | Section |
|
|
| 10.20.10.5 | Texas | Cookies and Cream Co | GA23867 | Router 1 CC | R | 11002392 | USA |
|
|
2. Create an empty database in SQL (database name Y)
3. Then import our excel spreed sheet to new database with Task -> Import Data... Follow the wizard and create the table HOLA
4. Run this script (it going to update the NPM database with our imported info)
UPDATE [NetPerfMon].[dbo].[Nodes]
SET
[NetPerfMon].[dbo].[Nodes].[Caption]=HOLA.[Node]
,[NetPerfMon].[dbo].[Nodes].[Kind]=HOLA.[Kind]
,[NetPerfMon].[dbo].[Nodes].[State]=HOLA.[State]
,[NetPerfMon].[dbo].[Nodes].[Site]=HOLA.[Site]
,[NetPerfMon].[dbo].[Nodes].[S_ID]=HOLA.[S_ID]
,[NetPerfMon].[dbo].[Nodes].[Section]=HOLA.[Section]
,[NetPerfMon].[dbo].[Nodes].[Phone]=HOLA.[Phone]
FROM [Y].[dbo].[NoNNN] HOLA
WHERE HOLA.[IP] = [NetPerfMon].[dbo].[Nodes].[IP_Address]
With this method I can update all my custom info and node names in seconds ;-)
