Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Query a specific node for all syslog messages in the database

Query a specific node for all syslog messages in the database

Table of contents
Created by Leif Amland, last modified by MindTouch on Jun 23, 2016

Views: 27 Votes: 0 Revisions: 3

Updated

Overview

By default, when you query the syslog table in the Database Manager it will only show the top 2000 rows. Please follow the steps below to get a list of all the syslog table entries.

Environment

All NPM versions

Steps

  1. Open the Database Manager and add the default server.
  2. Select and right click the name of the Orion database instance and select "New Query..."
  3. Enter the following query:
    Select * from Syslog
    where ip_address = 'xxx.xxx.x.xx'
  4. In place of the x's, you will want to place the IP address of the node you wish to see the syslog table entries for.
  5. Click Execute.

 

 

Last modified
23:24, 22 Jun 2016

Tags

Classifications

Public