Request for get data from Oracle database.
list Jayanta Kundu
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
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,
▸
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 Greg Hubbard
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> 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
▸
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
-----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 scriptson 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-----