Page 1 of 1

check table on Microsoft SQL server

Posted: Thu Oct 11, 2018 7:20 am
by bashar.abed
Hi,

we have nagios XI version 5.4.13 VM machine

We are writing the log into table on Microsoft SQL Server , and we need to have alert on some logs if appears

there is wizard or services on Nagios system to check above option

Thanks

Re: check table on Microsoft SQL server

Posted: Thu Oct 11, 2018 7:27 am
by scottwilkerson
You could use the MSSQL Query Wizard and write a simple query to select the count on the table in question

Code: Select all

select (*) from table
Set your warning and critical levels to alert if the threshold is breached