Xymon Mailing List Archive search

Request for get data from Oracle database.

list Ryan Novosielski
Tue, 04 Jan 2011 12:46:15 -0500
Message-Id: <user-9476342ec3f6@xymon.invalid>

-----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 <user-ae4522577e16@xymon.invalid
<mailto:user-ae4522577e16@xymon.invalid>> 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 <user-d0758a3e63c3@xymon.invalid
    <mailto:user-d0758a3e63c3@xymon.invalid>> 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
|$&| |__| |  | |__/ | \| _| |user-ae4522577e16@xymon.invalid - 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-----