cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

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.

0 Kudos
4 Replies
Level 7

It's been 6 years.  Do you all have this capability now.  If so, how do I do it?

0 Kudos
Level 7

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.

0 Kudos

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

0 Kudos

Hello,

Has there been any progress with this?

We need to be able to have a report which displays data returned by an SQL query but cannot condone the cost of NPM and APM just to do this?

Thanks in advance.

Andy.

0 Kudos