Convert trigger action temperature from Celsius to Fahrenheit

I have the display in my Solarwinds showing Fahrenheit but the trigger action is converting it to Celsius in the alert I'm trying to setup. I've tried adding this ${SQL: SELECT (${N=SwisEntity;M=Value}* 9 / 5) + 32 } from the following link but get the error posted below. Can someone help with getting this to work? I'm no SQL expert.

Error in bold:

FPC: JNP48Y8C-CHAS @ 0/*/* on TEST is Up as of 4/23/2024 9:33 AM current temperature 37 MACRO SQL ERROR - No column name was specified for column 1 of 'f5hc2gp3_a0

Trigger action:

An issue on an object you are monitoring occurred at ${N=Alerting;M=AlertTriggerTime;F=DateTime}.

${SensorDisplayName} on ${NodeName} is ${SensorOriginalStatus} as of ${DateTime} current temperature ${N=SwisEntity;M=Value}

Parents Reply Children
No Data