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

Is there a way to import data into a custom Information field on existing nodes from an access database or excel spreadsheet?

I have been given a spreadsheet with site records listing information pertinent to each site that is not in Orion NPM. I could see pasting this info into a custom text box/field that I already have set up for each node. What I am wondering is if there is a way to import them into the SQL database so that I do not have to type them in manually.

The spread sheet has 95 nodes with 48 columns of information.

Has anyone done this?

Find more posts tagged with

Accepted answers

All comments

borgan

The custom property is ideal for this. You would have to create a custom property to match each column in the source file that you want to import. Then, you import the spreadsheet to the custom property editor on the Orion website. Match the IP address of each node and choose a field in the source file and the matching custom property for each. That would be a quick way to get all of this data into SolarWinds.

Hope this helps.