Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn More.

 

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: 210 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