Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Network Performance Monitor (NPM) > Delete Unknown or Down Interfaces by Bulk

Delete Unknown or Down Interfaces by Bulk

Table of contents
Created by Jousseff Jaranilla, last modified by MindTouch on Jun 23, 2016

Views: 14 Votes: 4 Revisions: 13

Overview

This article describes how to delete Unknown or Down interfaces by bulk from the Orion Database.

Environment

All Orion Core Versions

Steps

Important Reminder:

  • Use an account with enough SQL privileges to update the table of your Orion database.
  • Create a back-up of your database in case you need to roll back later.

Using Database Manager:

1. On your Windows Server, search for Database Manager

2. Click on Add Default Server

3. Right-click on your SolarWindsOrion Database

4. Select New Query

5. Paste this query to VIEW all Interfaces that are currently Unknown or Down:

Select InterfaceID, Status, StatusLED From [dbo].[Interfaces]

Where StatusLED = 'Unknown.gif' OR StatusLED = 'Down.gif'

6. Paste this query to DELETE all Interfaces that are currently Unknown or Down:

Delete from [dbo].[Interfaces]

Where StatusLED = 'Unknown.gif' OR StatusLED = 'Down.gif'

Using SQL Server Management Studio:

1. On your Windows Server, search for SQL Server Management Studio

2. Login to your SQL Server Management Studio

3. Expand Databases

4. Right-click on your SolarWindsOrion Database

5. Select New Query

6. Paste this query to VIEW all Interfaces that are currently Unknown or Down:

Select InterfaceID, Status, StatusLED From [dbo].[Interfaces]

Where StatusLED = 'Unknown.gif' OR StatusLED = 'Down.gif'

7. Paste this query to DELETE all Interfaces that are currently Unknown or Down:

Delete from [dbo].[Interfaces]

Where StatusLED = 'Unknown.gif' OR StatusLED = 'Down.gif'

Related MindTouch Article: Search for Unknown or Down Devices

Last modified
22:07, 22 Jun 2016

Tags

Classifications

Public