check table on Microsoft SQL server

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
bashar.abed
Posts: 153
Joined: Tue Oct 11, 2016 1:34 am
Location: Ramallah West Bank Palestine
Contact:

check table on Microsoft SQL server

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: check table on Microsoft SQL server

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked