ODBC Query Test - Output query result to file/email on error

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
ptrevino
Posts: 2
Joined: Mon Mar 29, 2004 12:22 pm

ODBC Query Test - Output query result to file/email on error

Post by ptrevino »

Hello everyone...

I am trying to do the following:

1. Run a query via ODBC and then compare the data returned to see if it exceeds a threshold.
2. If it exceeds the threshold, send an email to the administrator.
3. Attach the output of the Query run in item #1 above to the email that is sent to the administrator.

I can do items 1&2 but not sure about how to do 3.

Any ideas?

Currently running v4.42

Thanks for the help!!!
KS-Soft
Posts: 12887
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

You may easily send value of the field that you are checking using %Reply% macro variable in e-mail body.
However if ODBC query returns several fields, HostMonitor will display (and send by e-mail) single field (field that you compare)

Regards
Alex
Post Reply