Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > How to clear discards and errors statistics for the day

How to clear discards and errors statistics for the day

Table of contents

Updated March 6, 2018

Overview

The Orion database still retains discards and errors of monitored interfaces for the rest of the day after clearing them in the device directly. This is more obvious on maps created in Network Atlas where interfaces errors this hour and today are shown. For this reason, the steps below outline how to clear errors and discards statistics collected by NPM within the day.

Environment

  • NPM 12.2
  • Network Atlas

Steps

  1. Open Database Manager
  2. Click "Add default server"
  3. Expand your server, right-click the database and hit "New query ..."
  4. Copy and paste the SQL query below replacing NAME with the name of the interface and NUMBER with the NodeID of the device where the interface is located.

    Note: To obtain the NodeID of a device, refer to How to obtain a node ID from the Web Console

  5. Click "Execute query"
UPDATE Interfaces SET InDiscardsThisHour = '0',
InDiscardsToday = '0',
InErrorsThisHour = '0',
InErrorsToday = '0',
OutDiscardsThisHour = '0',
OutDiscardsToday = '0',
OutErrorsThisHour = '0',
OutErrorsToday = '0' WHERE InterfaceName = 'NAME' AND NodeID = 'NUMBER'

 

 

Last modified

Tags

Classifications

Public