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,
Now the Cisco Temperature is monitored in Fahrenheit.
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,
- Select * from graphdetails where graphname like'%CiscoTemperature%'; (Note the GraphID from this query output)
- Select * from polldatatemplate where graphid=213; (check the polldatatemplate table filtering with the GraphID)
- 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.
New to ADSelfService Plus?
Related Articles
Configuring threshold values for disk partitions in OpManager
For the Servers, we discover Disk utilization using both WMI and SNMP. Also, we monitor the drive partitions that are available in those Servers. The customers found this very ...Configuring response time and packet loss threshold values for a group of devices in OpManager
In this video you'll learn how to set response time and packet loss threshold values for a group of devices in OpManager Daylight Saving Time(DST) not being updated in the OpManager
Issue: Daylight Saving Time(DST) difference is not reflected in OpManager. The Time that is being shown in "About" tab in OpManager UI will have 1 hour time difference with respect to the actual time. Reason: Daylight Saving Time(DST) changes that ...Resolving Pgsql Startup due to DNS issue
1. Stop the OpManager service and wait till all java/postgres processes are closed. (If postgres process doesn't exit for a long time, do not kill the process, instead, run StopPgsql.bat from cmd and wait for the process to terminate.) 2. Navigate ...How to create a custom report widget in OpManager?