Nagios Support Forum

I am trying to monitor log files on some MSSQL servers. On the my Exchange server I am doing this successfully by using the check_nrpe command: check_nrpe -s -H HOSTNAME -t 60 -c Check_Eventlog -a 'warning=count > 0' 'critical=count > 0' "filter=level = 2 AND log = 'Application' AND id in (2112...

WooHoo! I used your plugin and syntax and things look like they are working. check_mssql_nagios -H <server> -U '<domain\username>' -P '<password>' -p 4000 -t 60 -d master -Q 'select * from sysprocesses p1, sysprocesses p2 where p1.blocked \> 0 and p2.spid = p1.blocked' OK: Connect time=0.010067 seco...

check_mssql -H <server> -U '<domain\username>' -P '<password>' -p 4000 -t 60 -q 'select * from sysprocesses p1, sysprocesses p2 where p1.blocked > 0 and p2.spid = p1.blocked' Unknown option: q UNKNOWN - online or query is required. Is there a different plugin you are using? check_mssql --help Usage...

Still the same. Good call out, been trying to get this work so long my eyes are becoming crossed. check_mssql -H <server> -U '<domain\username>' -P '<password>' -p 4000 -t 60 -Q 'select * from sysprocesses p1, sysprocesses p2 where p1.blocked \> 0 and p2.spid = p1.blocked' UNKNOWN - Could not interp...

Unfortunately, I am getting the same thing. check_mssql -H <server> -U '<domain\username>' -P '<password>' -p 4000 -t 60 -Q 'select * sysprocesses p1, sysprocesses p2 where p1.blocked \> 0 and p2.spid = p1.blocked' UNKNOWN - Could not interpret server response. I also tried double quotes with the sa...

It there a way I can escape the character so it is rendered as a > and not redirect? I thought if I quoted the query it would just execute the string as is but it appears that may not be the case.

I was given these from a peer to use. Both are Perl scripts but the check_mssql_health I could get some values but unable to run against custom queries. (see attached) I was also pointed to this one as well but not sure how to configure the syntax with my original above. https://github.com/danfrueha...

I am using this: check_mssql -H <server> -U '<domain\username>' -P '<password>' -p 4000 -t 60 -Q "SELECT db.name ,tl.request_session_id,wt.blocking_session_id,p.OBJECT_ID,tl.resource_type,h1.TEXT ,h2.TEXT ,tl.request_mode FROM sys.dm_tran_locks AS tl INNER JOIN sys.databases db ON db.database_i...

I am having a time trying to get this working. I have a MSSQL 2012 and 2016 server that I am trying to check by running some custom queries. One is for checking blocking sessions. Our DBA's have a few others but this is the first time we have been trying to use Nagios to replace IPSentry. If anyone ...

Yes, I was jumping around the various boards looking for a solution.

Are you able to move this thread?