snmpcollector 4.03 includes incorrect samplerate value in QOS/ Breaks Static TOT

Article Id: 142322
Status: Published
Updated On: 10-01-2020 14:20
Products:
DX Infrastructure Management , NIMSOFT PROBES , DX Infrastructure Management
Issue/Introduction:

snmpcollector 4.03 includes the incorrect samplerate value in the QOS message and Breaks TOT threshold calculation

Example:
QOS Message for 1 min poll rate includes a samplerate of 1800 (This should be 60)
QOS Message for 5 min poll rate includes a samplerate of 9000 (This should be 300)
QOS Message for 10 min poll rate includes a samplerate of 18000 (This should be 600)

The incorrect samplerate is seen in DrNimbus and in the RN_QOS* table

Cause:

snmpcollector smallest poll interval value defaults to 30 seconds

Environment:

Release : 9.2.0

Component : UIM - SNMPCOLLECTOR

Resolution:

Add below key in snmpcollector probe's setup section via raw configure:

SMALLEST_POLL_INTERVAL = 1

Steps :
1. Deactivate probe
2. Open raw configuration of the probe in adminconsole.
3. Go to setup section
4. Add new key/value pair as shown below
5. Save the changes
6. Activate probe

Samplerate value in QOS Message for 1 min poll rate should now be 60
Samplerate value in QOS Message for 5 min poll rate should now be 300
Samplerate value in QOS Message for 10 min poll rate should now be 600

NOTE:

The samplerate value in the QOS message is stored in the database (RN_QOS_DATA_* tables)  and not visible through USM reports.

Use the following queries to check the samplerate value for a given QOS and Device

1. Select a device the is being monitored by the snmpcollector probe.

2. Replace 'devicename' with any device being monitored by the snmpcollector probe and run the query to identify its table_id and RN_QOS_DATA_* table.

In this example we are using QOS_AVAILABILITY_AVAILABILITY monitor.

select table_id, r_table from s_qos_data where source = 'devicename' and qos = 'QOS_AVAILABILITY_AVAILABILITY' 

3. Take the table_id and RN_QOS_Data_* table values and run the query below to check the samplerate column

To see current samplerate values:
select * from  RN_QOS_DATA_#### where table_id = #### order by sampletime desc;

To see samplerate values prior to adding the SMALLEST_POLL_INTERVAL =1 snmpcollector key
select * from RN_QOS_DATA_#### where table_id = #### order by sampletime asc;