KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

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

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
ptrevino



Joined: 29 Mar 2004
Posts: 2

PostPosted: Tue Jun 22, 2004 1:25 pm    Post subject: ODBC Query Test - Output query result to file/email on error Reply with quote

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
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12211
Location: USA

PostPosted: Wed Jun 23, 2004 8:56 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
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

KS-Soft Forum Index