Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Remove multiple interfaces using DB maintenance config

Remove multiple interfaces using DB maintenance config

Table of contents
Created by Zaquan Henry, last modified by MindTouch on Jun 23, 2016

Views: 12 Votes: 0 Revisions: 3

Overview

This article describes how to remove multiple interfaces using a script to reference the tables used by DB maintenance.

Environment

All NPM versions

Steps

  1. Go to C:\Program Files (x86)\SolarWinds\Orion\DatabaseMaintenance
  2. Open the InterfacesTableHandlers.handler file.
  3. Locate the following or similar:
    TableName="Interfaces"
    TableElementType="" 
    RemoveOrphanedDataProc="dbm_Interfaces_DeleteOrphans"
    RemoveStaleDataProc="" 
  4. Take note of the tables and locate the interfaces tied to the removed nodes.
  5. Create a script to remove the nodes and orphaned data.

 

 

Last modified
23:26, 22 Jun 2016

Tags

Classifications

Public