You should be able to insert the Custom SQL as long as it returns a single value, but it will need to be a regular SQL statement. This is what it should look like:
${SQL:Select IP_Address from Nodes where NodeID='${NodeID}'}
Unfortunately, this doesn't seem to work either. I tried it with this Statement:
${SQL:Select Node_AlertEMail from Nodes where NodeID='${NodeID}'}
Node_AlertEMail is a custom field with my e-mail address.
When testing this, the SQL is executed correctly in the Body of the mail but sending the e-mail doesn't work.
When I reopen the e-mail action the custom SQL ist truncated:
Regards
J. Derek
Answer from Solarwinds Support: It's not possible.
