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

ajl119 over 14 years ago

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 ajl119 over 14 years ago

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 mark_wiggans over 14 years ago in reply to ajl119

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
Cancel
Vote Up 0 Vote Down

Cancel
0 ajl119 over 13 years ago in reply to mark_wiggans

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.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 7 years ago

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

Cancel