Community and Support

            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.
            Updated: 13 Oct 2016 12:25 PM
            Helpful?  
            Help us to make this article better
            0 0