article Changing SNMP monitor values from String to Int to allow graphing

By default, manually adding an OID will set the value to a string.  Use the following ODBC query to change SNMP monitor values to an integer and allow graphing:

UPDATE erdc_parameter SET data_type_id=2, erdc_gui_type_id=2

WHERE name LIKE 'oid_output_%'

The advanced query version below allows the user to specify which service instance to modify.

UPDATE erdc_parameter SET data_type_id=2, erdc_gui_type_id=2

WHERE name LIKE 'oid_output_%' AND erdc_base_id IN

(SELECT eb.erdc_base_id FROM erdc_base eb inner join erdc_configuration econ (ec.erdc_base_id=eb.erdc_base_id), erdc_instance ei

WHERE ei.configuration_id = ec.id AND ei.erdc_instance_id IN (<ID>,<ID>,..etc))

Where <ID>: is the erdc_instance_id value from the erdc_instance table.

Note: if you attempt to change a single service that is a member of a service group, this query will modify the string to an INT value for all service group members.

Related Articles


Windows Event Log Monitor returns Output: Monitor failed: For inp...

RatingViews
article

This error indicates that the target agent server's up.time agent is incompatible with your monitoring station version. Please upgrade the agent on the impacted server and verify that this error is...

By: uptime Support | Date Created: 8-26-2010 | Last Modified: 8-10-2011 | Index: 497

  3155

File System Capacity Monitor string not matching

RatingViews
article

The string based mount matching within the file system capacity monitor is designed to accept a * wildcard at the end of the string only. Full regular expression matching is not supported....

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 8-10-2011 | Index: 298

  3208

IE Blocks an ActiveX Control During Graphing

RatingViews
article

A solution to prevent Internet Explorer from presenting ActiveX component security warnings when it should not be displaying them.

By: uptime Support | Date Created: 7-14-2009 | Last Modified: 6-14-2011 | Index: 375

  3173

SNMP monitor applet won't load

RatingViews
article

The SNMP monitor uses a java based applet to browse and select OIDs from available MIB files. On some browsers you may find that the applet fails to load, which makes the browser window appear as...

By: uptime Support | Date Created: 8-13-2010 | Last Modified: 8-13-2011 | Index: 483

  1942

Unable to browse MIB using the up.time SNMP monitor

RatingViews
article

When configuring the SNMP Monitor, you are able to add OID manually but can't browse the MIB by loading it. This can happen for a few reasons, but the most common is that the MIB you are trying to...

By: uptime Support | Date Created: 10-14-2009 | Last Modified: 8-13-2011 | Index: 438

  3872

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement