combining values in SQL database monitoring

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

combining values in SQL database monitoring

Post by dlukinski »

Hello Nagios support

How could we proceed about combining values, like calculating total number of databases and their size per instance when monitoring SQL?

Thanks
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: combining values in SQL database monitoring

Post by rkennedy »

Are you trying to use a certain plugin? This should be possible, but you'd have to write a bit of custom code to organize your data as needed unless there is something available at our exchange already.

Did you look at the exchange yet? https://exchange.nagios.org/index.php?o ... word=mysql
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: combining values in SQL database monitoring

Post by dlukinski »

rkennedy wrote:Are you trying to use a certain plugin? This should be possible, but you'd have to write a bit of custom code to organize your data as needed unless there is something available at our exchange already.

Did you look at the exchange yet? https://exchange.nagios.org/index.php?o ... word=mysql
Hi

Not that I think.

For Microsoft SQL server we need to calculate number of databases and their sizes (what you posted was for MySQL)
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: combining values in SQL database monitoring

Post by rkennedy »

Ah, here's the link for MSSQL.
https://exchange.nagios.org/index.php?o ... word=mssql

Do any of those work for you?
Former Nagios Employee
dlukinski
Posts: 1130
Joined: Tue Oct 06, 2015 9:42 am

Re: combining values in SQL database monitoring

Post by dlukinski »

rkennedy wrote:Ah, here's the link for MSSQL.
https://exchange.nagios.org/index.php?o ... word=mssql

Do any of those work for you?
Please close this case

Thank you
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: combining values in SQL database monitoring

Post by mcapra »

Closing per your request
Former Nagios employee
https://www.mcapra.com/
Locked