Re: [xymon] Request for get data from Oracle database.

[Ryan Novosielski <novosirj (at) umdnj.edu>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There is actually information in the FAQ's as well, with a sample test.
As long as you know how to use sqlplus, this will be very easy for you.

On 01/04/2011 12:32 PM, Greg Hubbard wrote:
> I agree with Ryan.  Look at the documentation for "custom tests" ( I
> think there is a "temperature" example.  You can get the Xymon client to
> schedule the test for you at whatever interval you choose, and then your
> test can post the statues (red/yellow/green) as well as anything else
> you want to post.  You can even set things up so any numerical results
> that you send can be graphed.
>  
> But it all starts by reading the documentation, taking time to
> understand the example(s), and then modifying them to do what you want
> to do.
>  
> GLH
> 
> On Mon, Jan 3, 2011 at 8:32 AM, Ryan Novosielski <novosirj (at) umdnj.edu
> <mailto:novosirj (at) umdnj.edu>> wrote:
> 
>     Seems you'd need to create an external script/test that will do
>     this. I believe there is a sample that comes with the distribution,
>     but I'm not certain. In any case, looking at the scripts
>     on xymonton.trantor.org <http://xymonton.trantor.org/> would be
>     instructive. These are launched by adding them to clientlaunch.cfg
>     on a client if I am not mistaken, and probably hobbitlaunch.cfg on a
>     server. Take a look at the documentation.
> 
>     -- Sent from my Palm Pre
> 
>     ------------------------------------------------------------------------
>     On Jan 3, 2011 5:11, Jayanta Kundu <jayantak007 (at) gmail.com
>     <mailto:jayantak007 (at) gmail.com>> wrote:
> 
>     Hi All,
> 
>      
> 
>     I would like get data from oracle database on a particular table.
> 
>     For example:
> 
>     SELECT count(1) from emp;
> 
>      
> 
>     I want to display the result of the above query into my xymon page.
> 
>     Kindly let me know what the steps are for do the same. Which files
>     need to modify/configure etc.
> 
>      
> 
>     With Regards,
> 
>     Jay. 
> 
> 
> 
> 
> -- 
> Disclaimer:  1) all opinions are my own, 2) I may be completely wrong,
> 3) my advice is worth at least as much as what you are paying for it, or
> your money cheerfully refunded.


- -- 
- ---- _  _ _  _ ___  _  _  _
|Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Sr. Systems Programmer
|$&| |__| |  | |__/ | \| _| |novosirj (at) umdnj.edu - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/CST-Academic Svcs. - ADMC 450, Newark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk0jXOYACgkQmb+gadEcsb4qLwCfZx9klUc6Oync07hxulRCHr0f
pjkAoMf4sJr0S47C3WDaXjbBxDPjvAdz
=iaPJ
-----END PGP SIGNATURE-----