Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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