This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How to email results of an SQL query

Hello,

We run a licensed copy of ipMonitor and have been running it for around a year now.

Many of our 'monitors' connect to a database and perform an SQL query. The results of the query can of course be tested (I.e. does column 2, row 1 have a positive integer for example).

Whilst the monitor itself may run well and alerts to when the data is wrong, is it possible at all to have ipMonitor email the returned table of data?

 

This is really very important for us as whilst it is important to know that some data is outside of expected values, the overall table of data needs to be manually inspected by a support person to be able to actually diagnose and fix the root cause.

Currently it is driving us nuts having to manually load up the appropriate SQL utility, connect to the database and retrieve the same table of data that ipMonitor has already retrieved and analyzed every time an alert is generated.

 

I understand it would be hard and largely impractical to store the table data in the ipMonitor database as it is not possible to predict the returned table structure etc.

However if you are able to test fields in the table data etc, then the table returned from the SQL query must be in ipMonitor’s memory, thus there should be no technical reason why ipMonitor could not also email the entire table when the test element fails for example.

Is this possible? If not, can you make it possible?

 

We have a full support agreement so please let us know if you need our software support codes etc.

 

Thank you for your time.

Andy.

Parents
  • Hello,

    Thank you for your reply.

    I don't know what happened but after I tried to do a quick reply, it came back with an error, lost my reply, then after refreshing the page your post seems to have gone too!

     

    Anyway, to answer your question; No, we do not use Orion NPM as it is to expensive for us. We bought ipMonitor for the task.

    We are only a very small company with 13 staff and we are trying to use ipMonitor to better cope with managing our infrastructure.

     

    Thanks for your time.

    Andy.

  • Andy-

    At this time it is not possible to report the values returned to an SQL query within a report.  This has been requested as a feature request in the past and is being considered for possible implementation within a future version of ipMonitor.  If you need this type of feature now, it should be possible using Orion NPM with the Orion APM module.  More on APM is found here:

    http://www.solarwinds.com/products/orion/application_monitor/apm_monitors.aspx

    Sincerely,

    Mark

Reply Children