<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Exchange Server">  <style></style> </head> <body> <font face="Calibri, sans-serif" size="2"> <div>I am trying to monitor our OpenEdge Database Application Servers on our AIX box with Nagios, and to send an alert based on a “tricky” situation, described below:</div> <div> </div> <div>The tool that I run locally on the AIX host to check our servers outputs the following:</div> <div> </div> <div>#asbman –name production –query</div> <div><font face="Courier New, monospace" size="2">PID State Port nRq nRcvd nSent Started Last Change </font></div> <div><font face="Courier New, monospace" size="2">2175264 AVAILABLE 15614 006968 007643 008661 Aug 29, 2010 19:03 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2">922080 AVAILABLE 15616 002675 002970 003465 Aug 30, 2010 09:22 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2">483832 AVAILABLE 15607 001740 001939 002204 Aug 30, 2010 10:02 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2">2936902 AVAILABLE 15620 001753 001955 002236 Aug 30, 2010 10:02 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2">3658058 AVAILABLE 15623 001742 001921 002190 Aug 30, 2010 10:02 Aug 30, 2010 11:16</font></div> <div><font face="Courier New, monospace" size="2">3027394 AVAILABLE 15608 001297 001377 001493 Aug 30, 2010 10:21 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2" color="#C00000"><b>3965150 </b><u><b>SENDING</b></u><b> </b><b> 15611 001290 001352 001465 Aug 30, </b><u><b>2010 10:21 Aug 30, 2010 </b></u><u><b>06</b></u><u><b>:</b></u><u><b>12</b></u><b> </b></font></div> <div><font face="Courier New, monospace" size="2">4186168 AVAILABLE 15615 001300 001379 001549 Aug 30, 2010 10:21 Aug 30, 2010 11:16 </font></div> <div><font face="Courier New, monospace" size="2">2044322 AVAILABLE 15617 001298 001369 001558 Aug 30, 2010 10:21 Aug 30, 2010 11:16</font></div> <div> </div> <div>I would want Nagios to raise an alert if State = SENDING for more than 6 hours (Last Change)? Would this be possible?</div> <div> </div> <div>Anyone have an idea of how I would do this?</div> <div> </div> <div>I guess one way would be to make a shell script to output “asbman –name production –query | grep “SENDING” >> status.txt” and have a check log type check read it and raise an error if stuff is found? But it does not exactly implement the “Last Change” date time idea, we will always have PIDs going from AVAILABLE to SENDING and back, but those that are stuck in SENDING for 6+ hours is of concern.</div> <div> </div> <div>Any help on this is appreciated.</div> <div> </div> </font> </body> </html> <pre>The Oppenheimer Group ---- CONFIDENTIAL This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.