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
Store

moving devices in solarwinds through SQL

FormerMember

How do you write a script in SQL to move devices between Solarwinds servers?

Find more posts tagged with

Accepted answers

All comments

BillFitz_Loop1

Hi Christopher,

If I am understanding your question correctly you are looking for the ability to move nodes between NPM deployments via a SQL script.

This is not supported in current versions of NPM. Due to the way nodes are created in the NPM database, along the with complexity of how historical data is stored, there is no method that allow you to 'move' nodes between NPM databases.

Thanks,

Bill Fitzpatrick

Loop1 Systems

www.loop1systems.com

FormerMember

What would be the Best way of doing this then?

BillFitz_Loop1

The simplest process is to build a report that lists the nodes you would like to discover in the new system, and then export those nodes either from report writer or from the web console. To export any report from the web console you can add &DataFormat=xls to the end of the URL for the report. (other supported formats for this export feature include csv, txt, xml, raw and jpg)

This exported list can then be used in the new system to discover a list of nodes in the Network Sonar Discovery.

Hope that helps!

Thanks,

Bill Fitzpatrick

Loop1 Systems

www.loop1systems.com

RichardLetts

Not SQL: but if you do not not need to move the historical data, just the monitoring configuration then there are powershell script examples to do this in either the SDK, or on the SDK forum.