Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Server & Application Monitor (SAM) > SAM 6.5 Administrator Guide > Manage the Orion Web Console and SAM > Import custom property values from an external document in SAM

Import custom property values from an external document in SAM

Table of contents
No headers

If you have a spreadsheet listing custom property values, such as asset tags of all your network nodes, you can make this information available for reporting and publication in the Orion Web Console.

Your data must be formatted as a table, and at least one column title should match an existing object property such as IP Address.

  1. Log in to the Orion Web Console as an administrator.
  2. Click Settings > All Settings in the menu bar.
  3. In the Node & Group Management grouping, click Manage Custom Properties.
  4. Click Import Values.
  5. Browse to the custom property data file, and click Open.
  6. Select the object type you want in the Import Values For drop-down, and click Next.
  7. For each detected Spreadsheet Column in your data, select the corresponding Orion Database Column, and select the Relationship between the columns.
    • Select Matches to indicate columns in the spreadsheet that correspond to existing columns in the SolarWinds Orion database, such as IP Address or MAC address.

      File:Success_Center/New_Articles/NPMAG_forMT_final/CO0/CustomProperties_Import_matches.png

    • Select Imports To to import the data in the spreadsheet column to the selected SolarWinds Orion database column.

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

    • Select Imports To, and select <No Match Found, Ignore> for any spreadsheet column you do not want to import.

      File:Success_Center/New_Articles/NPMAG_forMT_final/CO0/CustomProperties_Import_noMatchIgnore.png

    • Click 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.
  8. Click Import.

When you view the values of the object type, the values of the custom property you selected are populated.

 
Last modified

Tags

Classifications

Public