Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017December18 - Deletes > Syslogs Older than 24 hours are missing from the Syslog Viewer

Syslogs Older than 24 hours are missing from the Syslog Viewer

Created by Con Finucane, last modified by Kevin.Swinson on Dec 18, 2017

Views: 775 Votes: 0 Revisions: 9

Overview

Syslogs older that 24 hours are missing form the Syslog viewer. By default, Syslogs are retained for 7 days.

Environment

All NPM versions

Cause 

A script used to clean up large tables removed all data older than 24 hours from the Syslog table.

Resolution

  1. Check the Syslog retention settings: on the Orion Console  go to Settings > Polling Settings >Database Settings.
    1. Note: Syslog Messages Retention by default this is 7 days.
  2. Open the Database Manager to check the syslog table:
    1. Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager > Add Default Server.
    2. Expand the NPM Database (default) SolarWindsOrion.
    3. Select syslog table and then right-click Query Table.
    4. Run this query:
      SELECT * FROM [dbo].[SysLog] order by datetime asc
      This shows the oldest syslog in the database.
  3. Check with your Database Administrator to see what is removing the syslogs. The messages are being removed from the database by an external script outside the Orion application.
Last modified

Tags

Classifications

Public