Does anybody have a way to include results from a sql query inside the Alert notification? I want to display simply a database name and short message description under a given scenario. All the "real work" is already being done on the SQL Server side (to minimize the stress on the SolarWinds polling servers) and the table will be a relatively small table containing the details I will need in the message. I know SolarWinds has internal variables but how can I include query results(and any special formatting necessary) so that it can be included in the email notification if the alert is triggered.
Or is this something that I will have to leverage the Monitoring Template as well as Alerts? Was hoping I could just do within alerts only, but beggars can't be picky :-)
Thanks.