We pay for ipMonitor support.
Sorry for the delay. I'll route this over to the PM to try and get you an answer.
The closest thing you will be able to retrieve is the Monitor's Last Result value by using the "%monitorstatus%" token. In this case the value retrieved would be "Unable to connect to the remote device". It is currently not possible to retrieve the SQL response in any way and pass it into an Alert, although that has been requested in the past.
As you have active maintenance for ipMonitor, for any future issues or questions, please feel free to open a case using the following form:
Chris Foley - SolarWinds - Support Specialist
Support:866.530.8040 || Fax:512.857.0125
network management simplified | solarwinds.com