View previous topic :: View next topic |
Author |
Message |
ptrevino
Joined: 29 Mar 2004 Posts: 2
|
Posted: Tue Jun 22, 2004 1:25 pm Post subject: ODBC Query Test - Output query result to file/email on error |
|
|
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!!! |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Wed Jun 23, 2004 8:56 am Post subject: |
|
|
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 |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|