Private Logging to ODBC

lscarpace · Post by **lscarpace** » Thu Jul 05, 2007 4:53 pm

It would be useful to have the option to use ODBC to create a custom private log. I think it would be useful for creating graphs of traffic monitoring and other numeric data.

KS-Soft · Post by **KS-Soft** » Fri Jul 06, 2007 5:01 am

You may use "SQL Query" action instead

Regards
Alex

lscarpace · Post by **lscarpace** » Tue Jul 17, 2007 2:35 pm

Please forgive my lack of knowledge. Are you sugesting that I create an action profile to record the results to a DB?

I would create an action profile with a "good" status action of SQL querey and have it repeate until the status changes to bad.

Is this correct?

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jul 17, 2007 2:59 pm

lscarpace wrote:Please forgive my lack of knowledge. Are you sugesting that I create an action profile to record the results to a DB?

Correct. You may use "SQL Query" action: http://www.ks-soft.net/hostmon.eng/mfra ... htm#actSQL

lscarpace wrote:I would create an action profile with a "good" status action of SQL querey and have it repeate until the status changes to bad.
Is this correct?

It depends on "Repeat" parameter of an action. Quote from the manual: http://www.ks-soft.net/hostmon.eng/mfra ... properties
=====================
Repeat: N times; or until status changes Defines the number of repeats of the action if the status of the test was not changed. For example if you want to send an e-mail to a network administrator only once when test status changes, set this parameter to 1. If you need to execute action every time when test failed, set this option to "until status changes".
=====================
Actually, the trick is that you may specify different queries for the "Good" and "Bad" actions.

Regards,
Max