Cisco Fan Status Report, providing the MIB value translation for the numeric result of the get.
To to Modify the SQL, simply change the Sub Query Value to the unique Poller name used in the UNDP, in this case the value ciscoEnvMonFanState.
The MIB Values defined: 1: Normal, 2: Warning, 3: Critical, 4:Shutdown,5: NotPresent 6: Not Functioning
The text on the HTML report will also change according to status, 1: Blue, 2:DarkOrange,3:Red, 4: Blink, 5 and 6 : default colour)