Can you post this either here or add it to nagios exchange (probably better!)
Thanks. Greg On Fri, 2006-05-19 at 14:28 -0400, Janet Post wrote: > Az, > > Yes! I am very interested in this plug in!! > > Thank you. > Janet. > > -----Original Message----- > From: Az [mailto:[EMAIL PROTECTED] > Sent: May 19, 2006 6:42 AM > To: Janet Post > Cc: nagios-users@lists.sourceforge.net > Subject: Re: [Nagios-users] Oracle plugin > > Hi Janet, > > >I am looking for a plug-in that will run a query against an oracle > >database and return the results. > > > >I have found plugins that search for specific things -- like > tablespace, > >and archives, but nothing that will run a sql statement. > > > >Surely this plugin exists somewhere?!?! > > > > > I never found anything like this either so I rolled my own stored > procedure type plugin for both Oracle and MSSQL. The guts of it was one > of the parameters you passed it was a valid command for that RDBMS (so > it could be a select or a stored proc, the latter is what we did). It > expects 1 row, 2 columns back. A result code (OK, WARN, etc), and a > message. I havent bothered with perf stats at this point. > > Our DBAs wrote some standard stored procs they deployed as they saw fit > to spit out the results. Thus, I could manage Nagios and they could > write whatever queries on their DB they wanted without having to fiddle > with scripts on the Nagios server. > > I've not put them on Nagios Exchange, but if you're interested in seeing > > them, let me know. > > Cheers. > > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 > _______________________________________________ > Nagios-users mailing list > Nagios-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nagios-users > ::: Please include Nagios version, plugin version (-v) and OS when reporting > any issue. > ::: Messages without supporting info will risk being sent to /dev/null ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null