marunderwood

After many trials and errors, I found the solution. There's no need to concatenate using the + and the ''''' to get one quote mark. SWQL is already parsing and concatenating, so you just need to insert the single quote mark: Local time: ${SQL:Select DATEADD(hh,DATEDIFF(hh, GETUTCDATE(),…

Maybe this will help .... SQL appinsight alerting - component checks, but I'm not getting the drop-down list. But, if I type part of the name and arrow-up/down, it scrolls thru the options.

Ditto for me. Did you ever get an answer?

A similar idea is being worked on, https://thwack.solarwinds.com/ideas/1056. Whoot!! Whoot!!