Request for get data from Oracle database.
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.
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 <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.
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> 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 <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.
-----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-----
participants (3)
-
glh.forums＠gmail.com
-
jayantak007＠gmail.com
-
novosirj＠umdnj.edu