Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Export/Import custom property values

Export/Import custom property values

Table of contents
Created by James Fahey, last modified by MindTouch on Jun 23, 2016

Views: 4,534 Votes: 6 Revisions: 5

Overview

This article provides information on how to export or import custom property values through the Custom Property Editor on the Orion Web Console.

Environment

All versions of NPM

Steps

Exporting Custom Property Data

 

Note: You can only select custom properties for a single object type.

  1. Log in to the Orion Web Console using an account with administrative privileges.
  2. Click Settings on the top right corner of your Web Console.
  3. Click Manage Custom Properties in the Node & Group Management group.
  4. Check the custom properties you want to export, and click Export Values. 
  5. If you want to export custom property data for specific objects of the type previously selected, click Select <Objects>, and select the desired objects.
  6. Check the database columns you want to export and change which custom properties you want to export here.
  7. Select the file type to use for your exported data. This can be .csv, .txt, .html or .xls.
  8. Click Export. 

 

Importing Custom Property Data

Note: Your data should be formatted as a table and at least one column title should match an existing object property (for example, IP Address).

  1. Log in to the Orion Web Console as an administrator.
  2. Click Settings in the top right corner of the Web Console.
  3. Click Manage Custom Properties in the Node & Group Management grouping.
  4. Click Import Values. 
  5. Click Browse, navigate to your custom property data file, and click Open.
  6. Select the object type for which you are importing values from the Import-values dropdown.
  7. Click Next. 
  8. For each detected Spreadsheet Column in your data, select the corresponding Orion Database Column , and then select the appropriate Relatioship between the indicated columns. This can be either matches or imports to. 

    Note: This option overwrites any existing data in the corresponding in the custom properties.

    • Select matches to indicate columns in the spreadsheet that corresponds to existing columns in the Orion database (e.g. IP Address, MAC address).
    • Select imports to import the data in the spreadsheet column to the selected Orion database column.
    • Select imports to and select <No match found, ignore> for any spreadsheet column you don't want imported.
    • Select Create this custom property now to open the Add Custom Property in a new browser tab if you need to create a custom property for this spreadsheet column.
  9. Click Import.

Reference:

http://www.solarwinds.com/documentat...opertydata.htm

 

 

Last modified

Tags

Classifications

Public
/*]]>*/