Page History

By default, manually adding an OID will set sets 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.

...