Nagios Support Forum

We have a series of applications that work together to form this workflow system. Without going into too much detail, unless that is needed, we are trying to leverage Nagios XI to perform some monitoring services for this. The attached diagram is the workflow where each sub-system is dependent on the previous sub-system and then outputs the status. Obviously, if the sub-system doesn't get it's information there will be no status. Example, PRD5 processes and sends its results to OIT. OIT takes that information and adds to it its "stuff". The Content Collector never receives anything so the assumption is something with the OIT sub-system failed and we would like to have Nagios send out a notification. Is that even possible with Nagios XI?

This is what we were thinking. To have each sub-system send their transaction detail to a shared location and then have it funneled into either an Oracle or Microsoft SQL server database. Can Nagios XI read into a database and look for the "error" message and then dispatch the notification?

The print service will be ran three times a day so the thought is to have Nagios XI run these checkes three times a day a little before the print service executes. Some of the Developers were tossing around using a stored procedure. Others were just talking about writing a PowerShell script and not using Nagios XI while others thought since we have monitoring tool we should leverage it. Is it possible to send information to Nagios XI through an API for monitoring and notification?

So, I guess the easy question is in paragraph two. Is Nagios XI able to read information within an Oracle or MSSQL server database? If it can than is it possible to have the table or record with the "error" message included in the notification message?

Is anyone doing something similar to day and have any example of leveraging Nagios XI to monitor and alert on something simliar?

We have a wizard, the MSSQL query one. This will monitor a specific query, for a specific string output. I believe that's what you're looking for.

Here's a screenshot -

Not really what we were looking for but the Developer's think we might be able to do something with a web service call which Nagios could check using check_http. Meeting scheduled early next week so I'll keep you posted.

We'll keep this open for you!