Xymon Mailing List Archive search

Request for get data from Oracle database.

4 messages in this thread

list Jayanta Kundu · Mon, 3 Jan 2011 15:39:17 +0530 ·
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.
list Ryan Novosielski · Mon, 3 Jan 2011 09:32:09 -0500 ·
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 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> wrote: 


Hi All,

 
quoted from Jayanta Kundu

I would like
get data from oracle database on a particular table. 

For example:

SELECT
count(1) from emp;

 
quoted from Jayanta Kundu

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.
list Greg Hubbard · Tue, 4 Jan 2011 11:32:57 -0600 ·
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
quoted from Ryan Novosielski

On Mon, Jan 3, 2011 at 8:32 AM, Ryan Novosielski <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 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
quoted from Ryan Novosielski
a look at the documentation.

-- Sent from my Palm Pre

 On Jan 3, 2011 5:11, Jayanta Kundu <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.
list Ryan Novosielski · Tue, 04 Jan 2011 12:46:15 -0500 ·
-----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.
quoted from Greg Hubbard

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
quoted from Greg Hubbard
    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-----