Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

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