Mutiline reply from SQL query

bobbaij · Post by **bobbaij** » Fri Mar 06, 2020 6:38 am

I'm probably asking for the moon and stars, but need to know if this is possible with Hostmonitor.

We have our Hostmonitor server running on a Azure Windows server, with Active RMA agents running in the local networks of our customers. We monitor the Oracle DB's with various ODBC tests. That works like a charm.

But is it possible to get a multi row/column result of a query the %reply% field?
Am I right in concluding that this is not possible?

An example of such a query could be the top 5 SQL queries with username. Could you think of a way to get this result to the central Hostmonitor server, and use the reply data to fill a table in a database using Hostmonitor?

Thanks in advance!

KS-Soft · Post by **KS-Soft** » Fri Mar 06, 2020 8:51 am

Sorry, HostMonitor checks just specific field.
Probably we can add option to store entire row or may be several rows..

But I think you are using pretty old HostMonitor, version 10.nn?
Support term expired in 2017?
Also Professional license does not allow to provide monitoring service to 3rd party.

Regards
Alex

bobbaij · Post by **bobbaij** » Mon Mar 09, 2020 12:58 am

Hi Alex,

thanks for the info.

We're using HM 12.26.

Regarding the license. The info you have is most likely outdated. We've purchased a new license. Is there a mail address I can use to discuss this further?

KS-Soft · Post by **KS-Soft** » Mon Mar 09, 2020 9:29 am

support@ks-soft.net
or just click HostMonitor/RCC menu Help->Support

Regards
Alex