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 > Archive > 2017December4 - WIP Deletes > 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 Kevin.Swinson on Dec 04, 2017

Views: 54 Votes: 0 Revisions: 5

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