Getting alerts about neighbors being down after removing routing neighbors in NPM

8/28/2019 3:54 PM

3/30/2022 7:33 PM

After removing routing neighbors you continue to get alerts about the Neighbor being down.  Acknowledging them does not resolve the issue.

Network Performance Monitor

Retention for routing neighbors is 30 days and updates when the Orion Database Maintenance runs.

You can remove this in the NPM_RoutingNeighbor table manually. Below are the steps for your reference.

Note: Please make sure that you have a backup of SolarWinds database since you are going to remove data from one of its tables, NPM_RoutingNeighbor table.

 

1. Launch Database Manager from the Orion server (Start > All Programs > SolarWinds Orion > Database Manager).
2. From the Database Manager, click on Add Default Server. This will connect to the SQL server hosting the SolarWinds database.
3. From the list of databases, look for your SolarWinds database. Right-click it, and then select Query Table.
4. Enter the following query:

   -- Scripts are not supported under any SolarWinds support program or service. 
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
   -- disclaims all warranties including, without limitation, any implied warranties 
   -- of merchantability or of fitness for a particular purpose. The risk arising 
   -- out of the use or performance of the scripts and documentation stays with you. 
   -- In no event shall SolarWinds or anyone else involved in the creation, 
   -- production, or delivery of the scripts be liable for any damages whatsoever 
   -- (including, without limitation, damages for loss of business profits, business 
   -- interruption, loss of business information, or other pecuniary loss) arising 
   -- out of the use of or inability to use the scripts or documentation.
   
   SELECT * FROM [dbo].[NPM_RoutingNeighbor]
   where Isdeleted = '1'

5. Click Execute Query. This will show the neighbors that are tagged as yes/true under IsDeleted column, which means no longer available.
   From the result of the query, you should see the neighbors (IP Addresses). To remove this, proceed with the next steps.
   
   6a. Click Enable Table Editing.Highlight the entire row of the neighbor (IP Address). Then right-click it and select Delete the Selected cell(s).
   
   6b. Once deleted, click Execute query again to confirm that neighbors have been removed.
   
   OR
   
   6c. If table editing permissions is greyed out, Run this query instead:

   -- Scripts are not supported under any SolarWinds support program or service.  -- Scripts are provided AS IS without warranty of any kind. SolarWinds further  -- disclaims all warranties including, without limitation, any implied warranties  -- of merchantability or of fitness for a particular purpose. The risk arising  -- out of the use or performance of the scripts and documentation stays with you.  -- In no event shall SolarWinds or anyone else involved in the creation,  -- production, or delivery of the scripts be liable for any damages whatsoever  -- (including, without limitation, damages for loss of business profits, business  -- interruption, loss of business information, or other pecuniary loss) arising  -- out of the use of or inability to use the scripts or documentation. DELETE FROM [dbo].[NPM_RoutingNeighbor] where Isdeleted = '1'

   
   
   7. After the previous steps, go back to the node that used to have these neighbors before. They should no longer be present under the Routing Neighbors table.