0 Replies Latest reply on Mar 22, 2010 3:34 PM by charly_DF

    Bulk rename nodes and add or update custom propertys

    charly_DF

      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  StateSiteS_IDNodeKindPhoneSection

      10.20.10.5TexasCookies and Cream CoGA23867 Router 1 CCR11002392    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 ;-)