Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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