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) > Search for Unknown or Down Devices

Search for Unknown or Down Devices

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

Views: 4 Votes: 2 Revisions: 7

Overview

This article describes how to search for Unknown or Down devices using Database Manager or SQL Management Studio.

Environment

All Orion Core Versions

Steps

Note: Use both SQL Query on either Database Manager or SQL Management Studio

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.

 

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.

Query Nodes that are Unknown or Down:

Select NodeID, SysName, IP_Address, ObjectSubType, Status, StatusLED From [dbo].[NodesData]

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

Query Interfaces that are Unknown or Down:

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

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

Related MindTouch Article: Delete Unknown or Down Interfaces by Bulk

 

Last modified
23:31, 22 Jun 2016

Tags

Classifications

Public