Email ODBC Results

DainMuller · Post by **DainMuller** » Wed May 04, 2011 9:52 am

If I set up an ODBC Test to run a query, is there an easy way for it to return those results to me in an email?

KS-Soft · Post by **KS-Soft** » Wed May 04, 2011 10:31 am

If you setup ODBC Query test to check some field of the table, value of this field will be displayed in Reply field of the test. So you may use %Reply% variable in e-mail template.
Otherwise HostMonitor does not check field values...

Regards
Alex

michael_volk · Post by **michael_volk** » Thu Jan 26, 2012 4:17 am

Hello,

We would like to pass all the values in the e-mail. Is that possible?

Greetings Michael

KS-Soft · Post by **KS-Soft** » Thu Jan 26, 2012 9:44 am

all the values? Dataset returned by SQL Query? No, there is no such option.

Regards
Alex

michael_volk · Post by **michael_volk** » Fri Jan 27, 2012 3:17 am

Hi Alex,

can be added to the wish list with? Can you put this differently?
Greetings Michael

KS-Soft · Post by **KS-Soft** » Fri Jan 27, 2012 6:53 am

H'm, I am not sure this task fits within "network monitoring" scope

Probably you just need some script for your SQL database?

Regards
Alex

michael_volk · Post by **michael_volk** » Mon Jan 30, 2012 1:39 am

Hi Alex,

the response of the test is monitored for the tablespaces. it monitors the value in percent and the return should be the name of the bad tablespace.

Greetings Michael

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Jan 30, 2012 8:42 am

Could we see your SQL Query for checking tablespaces ?

KS-Soft · Post by **KS-Soft** » Mon Jan 30, 2012 9:49 am

Do you mean your query returns 2 fields, you want to check one but send by e-mail both fields?

Regards
Alex

michael_volk · Post by **michael_volk** » Tue Jan 31, 2012 8:05 am

I would like to check one field and two fields to send a mail.

Regards

Michael

KS-Soft · Post by **KS-Soft** » Tue Jan 31, 2012 8:21 pm

Usually several fields can be combined into one, e.g. query can check space, select most used tablespaces (when used space > some threshold) and return space+name as single field in descending order.

Regards
Alex