Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

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


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.


  • NPM 12.2
  • Network Atlas


  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