How To convert the Temperature Value from Celsius to Fahrenheit?

How To convert the Temperature Value from Celsius to Fahrenheit?

Question: 

How to convert  Cisco 2800 Temperature value from Celsius to Fahrenheit.

Solution:

This is the default OID of Cisco Temperature in Celsius (1.3.6.1.4.1.9.9.13.1.3.1.3.1)

Formula to convert the value from Celsius to Fahrenheit : 

Fahrenheit = 9/5 * Celcius + 32

Connect to the OpManager Database (If MSSQL -- connect to the MSSQL studio), 

For MYSQL & PGSQL follow the steps listed in the below KB to connect to Database.

https://support.zoho.com/portal/manageengine/helpcenter/articles/connecting-to-the-opmanager-database

The steps followed are common for both MYSQL, PGSQL and MSSQL,
  1. Select * from graphdetails where graphname like'%CiscoTemperature%';  (Note the GraphID from this query output)
  2. Select * from polldatatemplate where graphid=213; (check the polldatatemplate table filtering with the GraphID)
  3. This is how the formula to be substituted on the OID column of polldatatemplate 
        update polldatatemplate set OID='(9/5)*(.1.3.6.1.4.1.9.9.13.1.3.1.3.1+32)' where graphid=213;

Now remove and re-add the Cisco Temperature monitor associated to the device, so that it applies formula of Fahrenheit.

Now the Cisco Temperature is monitored in Fahrenheit.
                New to ADManager Plus?

                  New to ADSelfService Plus?