Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > SQL query showing nodes on Orion using a specified community string

SQL query showing nodes on Orion using a specified community string

Table of contents
Created by Roengen Mendoza, last modified by Rodim Suarez on Mar 08, 2017

Views: 46 Votes: 0 Revisions: 4

Updated March 9, 2017

Overview

During troubleshooting, it is possible to look at a table showing nodes using a specified community string.

Environment

All NPM versions

Steps

  1. Open Database Manager > Add Database.
  2. Expand the Orion Database > right click on NodesData table.
  3. Type the following query on the text area  SELECT * FROM [dbo].[NodesData].
  4. Click Execute query to pull out all the nodes having the community string JHCNetFlow.

 

Last modified

Tags

Classifications

Public