Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Configuration Manager (NCM) > Import nodes to NCM using a .CSV file

Import nodes to NCM using a .CSV file

Table of contents

Updated March 6, 2017

Overview

This article provides steps for NCM 7.x  to import nodes into NCM from a spreadsheet. 

Environment

  • NCM version 7.x

Steps

Use the Nodes Importer tool. It is a utility that enables importing nodes to the Orion Platform database as a batch.

  1. Download the NCM Node Importer Tool.
  2. Extract the files from the ZIP archive into a local directory.
  3. Copy NCM.NodeImporter.exe and NCM.NodeImporter.exe to the SolarWinds Orion installation folder.
    The default location is C:\Program Files (x86)\SolarWinds\Orion.

    Note: The SolarWinds.NCM.NodeImporter.exe.config file contains information required for establishing connection to the Orion Platform.Do not modify it.

  4. Prepare a .CSV file with data organized based on the following template:

     

    Column Name

    Allowed Value

    Description

    IsRequried

    IP Address

    Ipv4 or Ipv6

    IP

    TRUE

    SNMP Level

    0,1,2,3

    0 = None (polled via ICMP)

    1,2,3 = Version of SNMP

    TRUE

    NodeCaption

    string

     

    FALSE

    NodeGroup

    string

     

    FALSE

    ReverseDNS

    string

     

    FALSE

    Community

    string

     

    FALSE

    CommunityReadWrite

    string

     

    FALSE

    SysName

    string

     

    FALSE

    SysDescr

    string

     

    FALSE

    SysContact

    string

     

    FALSE

    SysLocation

    string

     

    FALSE

    SystemOID

    string

     

    FALSE

    Vendor

    string

     

    FALSE

    VendorIcon

    string

     

    FALSE

    MachineType

    string

     

    FALSE

    OSImage

    string

     

    FALSE

    OSVersion

    string

     

    FALSE

    NodeComments

    string

     

    FALSE

    UseUserDeviceCredentials

    0,1

     

    FALSE

    Username

    string

     

    FALSE

    Password

    string

     

    FALSE

    EnableLevel

    <no>,enable,enable 0,enable 1 .. enable 15</no>

     

    FALSE

    EnablePassword

    string

     

    FALSE

    DeviceTemplate

    string

     

    FALSE

    ExecProtocol

    TELNET,SSH1,SSH2,SSH auto

     

    FALSE

    CommandProtocol

    SNMP,TELNET,SSH1,SSH2,SSH auto 

     

    FALSE

    TransferProtocol

    TELNET,TFTP,SCP,SSH1,SSH2,SSH auto 

     

    FALSE

  5. Double-click NCM.NodeImporter.exe.
  6. Browse to the .CSV source file you created, and then click Next.
  7. Verify the symmetry of the source and input columns of data, and then click Next.

    The utility imports data.

  8. Click Exit when importing is complete.

 

Last modified
09:24, 24 Jul 2017

Tags

Classifications

Public