Is it possible to list Interface which has been changed Interface Speed?

Products

• CA eHealth

Issue/Introduction

Question: 

Sometimes, Interface Speed in eHealth element is needed to be updated with changing Override* Speed attribute. Is it possible to list these elements which changed Override Speed?

 

*About Override

eHealth discovery process takes interface speed from device's SNMP MIB. However, when you would like to change this speed, you can configure from "Poller Configuration" => "Modify Element" => "Override"

<Please see attached file for image>

 

Answer:

Currently, eHealth does not have functionality to filter for override speed. 

However, since this attribute is saved in NH_ELEMENT table, following SQL query can be used to list it. 

              Select NAME,OVERRIDE_SPEED,OVERRIDE_SPEED1 from NH_ELEMENT where OVERRIDE_SPEED !=0 OR OVERRIDE_SPEED !=0;

 

Inbounded override speed is saved in OVERIDE_SPEED column. Outbounded override speed is saved in OVERRIDE_SPEED1 column.

 

If interface speed has not been changed, these columns stays 0. 

 

Additional Information:

TEC523237 How eHealth stores speeds and user set speeds (override speeds)

 

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: