Submit a ticketCall us

AnnouncementsCome see SolarWinds at VMUG Frankfurt

SolarWinds is delighted to attend the upcoming VMUG which will take place at Kap Europa in Frankfurt on June 19th, 2018.

See event details.

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

Tags

Classifications

Public