SQL Store Procedures

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

SQL Store Procedures

Post by tavo2k4 »

Hello,
I am testing Nagios as a proof of concept to some of our customer so they can monitor our application.

Is there a Document on how to set up Nagios to execute SQL Store Procedures and display results in an informative way?

For example, how to monitor the row count of a table, if it reaches a threshold of 1000 it will display a error or warning message.

Thank you,

Gus G.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: SQL Store Procedures

Post by abrist »

MSSQL or MYSQL?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
tavo2k4
Posts: 19
Joined: Thu Jan 24, 2013 9:17 am

Re: SQL Store Procedures

Post by tavo2k4 »

Well it is Sybase actually, but I read somewhere that I can use MSSQL when configuring Nagios.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: SQL Store Procedures

Post by abrist »

Have you taken a look at the mssql plugin below?
http://exchange.nagios.org/directory/Pl ... ts/details
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked