Date: Fri, 29 Mar 2024 13:56:53 +0000 (UTC) Message-ID: <1600816035.5771.1711720613369@ip-10-0-1-161.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5770_554881961.1711720613357" ------=_Part_5770_554881961.1711720613357 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
By default, manually adding an OID will set the value to a strin= g. Use the following ODBC query to change SNMP monitor values to an i= nteger and allow graphing:
UPDATE erdc_parameter SET data_type_id=3D2, erdc_gui_type_id=3D2
WHERE name LIKE 'oid_output_%'
The advanced query version below allows the user to specify which servic= e instance to modify.
UPDATE erdc_parameter SET data_type_id=3D2, erdc_gui_type_id=3D2
WHERE name LIKE 'oid_output_%' AND erdc_base_id IN
= &nb= sp; = (SELECT eb.erdc_base_id FROM erdc_base eb inner join erdc_configuration ec= on (ec.erdc_base_id=3Deb.erdc_base_id), erdc_instance ei
= &nb= sp; = WHERE ei.configuration_id =3D ec.id AND ei.erdc_instance_id IN (<I= D>,<ID>,..etc))
Where <ID>: is the erdc_instance_id value from the erdc_instance t= able.
Note