Network Management

Query a specific node for all syslog messages in the database

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.

First published date

11/1/2018 6:11 PM

Last published date

10/22/2019 3:32 PM

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.

Product section

Network Performance Monitor

Resolution

  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 = '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.

Optionally, you can use the query below and specify a date range.

Select * from Syslog
where ip = 'xxx.xxx.x.xx'
and ((datetime > '09/01/2019') and (datetime < '10/22/2019'))