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
