Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Columns matching when importing custom properties

Columns matching when importing custom properties

Table of contents
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,463 Votes: 0 Revisions: 8

Overview

When importing custom property values from an external spreadsheet, the Custom Property Editor will attempt to logically match column labesl in the spredasheet to corresponding database columns. On the Match Columns view, columns that are read from the spreadsheet to be imported are listed on the right. For each spreadsheet column, select whether the object data should Match with the corresponding object data in the Orion database or Import to the Orion database as corresponding object data.

Environment

All NPM versions

Detail

For example, a spreadsheet that is a simple list of named nodes with corresponding IP addresses and physical locations would look similar to the following:

Name IP Address City State
Node_1 10.10.120.1 Austin Texas
Node_2 10.10.120.2 Austin Texas
Node_3 10.10.120.3 Austin Texas

On import, the Custom Property Editor would list the following as Spreadsheet Columns:

  • Name
  • IP Address
  • City
  • State

Typically, you will want to match your imported nodes by name and IP address have the rest of the data imported into your SolarWinds database. In this case:

Spreadsheet Column Relationship Orion Database Column
Name matches Caption
IP Address matches IP_Address
City imports to City
State imports to State

Click Import, and the location data (City and State) for each corresponding node, identified by name and IP address, are imported from the spreadsheet into the Orion database.

Last modified

Tags

Classifications

Public