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?
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>
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.
TEC523237 How eHealth stores speeds and user set speeds (override speeds)