Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities.
NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 870 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

Tags

Classifications

Public