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.
| 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. |