Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2018Jan2 - Deletes > Remove multiple interfaces using DB maintenance config

Remove multiple interfaces using DB maintenance config

Table of contents
Created by Zaquan Henry, last modified by Kevin.Swinson on Jan 02, 2018

Views: 801 Votes: 0 Revisions: 4

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

Tags

Classifications

Public