Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 881 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