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

lost basic alerts on hardware migration

I had to migrate my npm hardware and it appears none of my basic alerts came over to the new box. I want to get this straightened out prior to moving up to 10.2. Any ideas as to what I failed to copy off the old server?

SolarWinds Orion Core 2011.1.1, IPAM 2.0, NCM 6.1, NPM 10.1.3, NTA 3.8.0, IVIM 1.1.2

Find more posts tagged with

Accepted answers

All comments

sean.martinez

The Basic Alerts are tied to the Engine ID of the Orion Server since they run locally to the system only. As long as there is only 1 Orion Engine, please execute the following SQL:

Update Alerts set EngineID=(select EngineID from Engines)

You will need to run the above in SQL Studio Manager or in our Database Manager

For SQL Studio Manager:

Start > All Programs > Microsoft SQL Server > SQL Server Management Studio

Using sa credentials, log in to your SQL Server\Instance

If you have forgotten your SQL Server\Instance see the Note at the Bottom

Click plus sign in the database, and right click NetPerfMon, and click New Query, paste the query and apply execute, it will let you know by say (x rows affected)

For our Database Manager:

Start> Programs> Solarwinds Orion> Advanced Features> Database Manager

Click New Server

Enter in your SQL Server\Instance and the Account information

If you have forgotten your SQL Server\Instance see the Note at the Bottom

Expand out the NetPerfMon Database.

Right Click on any Table and select Query Table
Clear out the “Select Top 1000 * from (Table)” and enter in the Query information and select Refresh

Note: If you have forgotten your SQL Server\Instance, you can find this information under Start> Programs> Solarwinds Orion> Configuration and Auto-Discovery> Configuration Wizard, then Database and Next. The Top Entry will be your SQL Server\Instance.

adeimel

Thanks Sean thats very helpful but I'm still not seeing them populate, however I see them in the alerts table. I suspect from reading your caution on the number of engines that my issue may lie there.

Our NPM migration was due to failed hardware which came up during the cutover briefly resulting in an additional poller being registered.

My alerts table shows these basic alerts tied to EngineID 4.

How do I determine what that value should be?

sean.martinez

You can see all of the Orion Engines in the Engines Table. If there is more than 1 Primary under the ServerType Column you will need to do the following:

Go into Start> Programs> SolarWinds Orion> Advanced Features> Monitor Polling Engines.

Go to Servers> Poller Load Balancing.

Select all of you nodes

Go to Polling Engines> Move selected nodes to> select your current Orion.

It will then ask if you want to remove the old polling Engine, Press Yes

Open System Manager, you should see all of your Nodes you added to this Server.

Then execute the SQL Statement and it will update to the only Engine in the Database,

adeimel

That also didn't seem to work as I must have already cleared out the second poller.

I did try from SQL studio with the above query and at least saw some rows affected but the GUI did not update. I confirmed in the engines table that the alerts table was correct so I bounced the box and now everything seems well in the world.

Thanks Sean1