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