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.