Network Management

How to export nodes on one server for discovery on another

This article provides steps to export the nodes list from your old Orion Platform server to your new Orion Platform server.

First published date

10/10/2018 8:45 PM

Last published date

3/8/2023 2:15 PM

Overview

This article provides steps to export the nodes list from the Orion Platform database for the old installation, and import them  to your new Orion Platform server as a Network Discovery job.

Product section

Network Performance Monitor

Resolution

Export the nodes

  1. Go to Start > All Program > SolarWinds Orion > Advance Feature > Database Manager.
  2. Expand the Database, and open any Table in your Database. For example, right-click Table > Query table.
  3. Remove the default Query, paste the SQL Query below, and then click Execute Query:
    -- Scripts are not supported under any SolarWinds support program or service.
    -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
    -- disclaims all warranties including, without limitation, any implied warranties
    -- of merchantability or of fitness for a particular purpose. The risk arising
    -- out of the use or performance of the scripts and documentation stays with you.
    -- In no event shall SolarWinds or anyone else involved in the creation,
    -- production, or delivery of the scripts be liable for any damages whatsoever
    -- (including, without limitation, damages for loss of business profits, business
    -- interruption, loss of business information, or other pecuniary loss) arising
    -- out of the use of or inability to use the scripts or documentation.
    
    SELECT IP_Address FROM NODES
  4. Copy the list of IP addresses to a text editor. 

Import the nodes to a different server

  1. Open the Web Console of your new Orion Platform server and log in as an administrator.
  2. Go to Settings > Network Sonar Discovery.
  3. Create a new discovery, and enter the credentials.
    Note: When prompted for the Network Selection, select Specific Nodes Discovery type from the box on the left.
  4. Copy the IP addresses exported.
    Note: Enter one IP address per line, with no other punctuation. For example:
    192.168.1.1
    192.168.1.2
  5. Let the Orion Platform scan and import these devices.

Find the community string and polling method

To know the community string and polling method of the device, run the following query:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT IP_Address, ObjectSubType,Community FROM NODES