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

Add bulk nodes

moshera

Hi all,

is there a way to add bulk of nodes listed in excel sheet ?

Find more posts tagged with

network_monitoring

network_management

npm

Accepted answers

All comments

trilobite_rex

you can copy the names out of the excel spreadsheet and paste under IP addresses in network discovery.

moshera

thanks for your answer, I know this method, but I was asking for a new approach to add multiple different nodes in excel sheet with just one click.

knowing that this feature already exists in other network monitor programs

bobmarley

Bulk Import ICMP Nodes - THWACK

yellowtj

You can also do it through the API with either PowerShell or Python but it's going to take some work to get it done. Is this a one off or something that will be ongoing?

stuartd

There is a way to do this, but it is limited.

If you are adding network nodes, eg switches then use the Settings > Network Discovery approach otherwise you will have to individually go and 'list resources' for each node anyway, essentially eliminating any time saved by bulk importing. TBH - whatever you add, if they are SNMP or WMI accessible nodes then network discovery is the way.

Otherwise, a basic add node, IP and name approach could be:

#******* SET IP ADDRESS TO NPM SERVER YOU WANT TO CREATE NODES ON******


$OrionServer="NAME_or_IP_of_SWI_Server"


#******* Set path to CSV file containin node names *****


# The CSV file should have THREE COLUMNS

# The FIRST column should have a header cell called "NodeName"

# The cells below are the names of the external nodes to create

# The SECOND column should have a header cell called "IPA"

# The cells below it should have the IP addresses associated with each of the nodes to create

# The THIRD column should be called "Load"

# The cells below this should contain a "Y" for each node you wish to create which allows you to have one big list but not create them all at the same time if you don't want to)


$nodeListFile="x:\YOUR_DIR\NodesList.csv"


#**** The script will ask for credentials.  Must have Node Manager rights*****

$creds=Get-Credential

$swis=Connect-Swis -Credential $creds -Hostname $OrionServer


try {$nodes=Import-Csv $nodeListFile}


catch {Write-Host "Could not import file.  Check path and type";Break}


ForEach ($externalnode in $nodes)


{

    $externalNodeName=$externalnode.nodename

    $externalIpAddress=$externalnode.ipa

    if ($externalnode.Load -eq 'Y')


    {

        $nodeExists = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE Caption='$externalNodeName'"

        if (-not $nodeExists)

        {

            Write-Host "Creating node:"$externalNodeName

            # add the external node

            $newNodeProps = @{Caption = $externalNodeName;Vendor="Placeholder";IPAddress = $externalIpAddress;EngineID = 1;ObjectSubType = "ICMP";External=$TRUE;}

            $newNodeUri = New-SwisObject $swis -EntityType "Orion.Nodes" -Properties $newNodeProps

            $newNode = Get-SwisObject $swis -Uri $newNodeUri


              # WAIT 1 SECOND (To avoid overloading NPM server.  Can be removed)

#            Start-Sleep -Milliseconds 1000  

        }

        else

        {

            Write-Host "Node already exists:"$externalNodeName  

        }

    }

    else

    {

        Write-host "Skipping node: $externalNodeName"

    }

}