Search found 748 matches
- Mon Apr 20, 2020 1:35 pm
- Forum: Open Source Nagios Projects
- Topic: Monitor Windows Logs with NSClient++
- Replies: 0
- Views: 1586
Monitor Windows Logs with NSClient++
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...
- Fri Jan 17, 2020 1:30 pm
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Thu Jan 16, 2020 8:38 am
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Thu Jan 16, 2020 8:24 am
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Thu Jan 16, 2020 7:47 am
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Wed Jan 15, 2020 7:40 am
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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.
- Tue Jan 14, 2020 1:01 pm
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Tue Jan 14, 2020 6:59 am
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Re: Check MSSQL run custom query
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...
- Mon Jan 13, 2020 2:56 pm
- Forum: Open Source Nagios Projects
- Topic: Check MSSQL run custom query
- Replies: 15
- Views: 7957
Check MSSQL run custom query
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 ...
- Mon Jun 10, 2019 6:01 am
- Forum: Nagios XI
- Topic: PowerShell script schedule downtime
- Replies: 3
- Views: 399
Re: PowerShell script schedule downtime
Yes, I was jumping around the various boards looking for a solution.
Are you able to move this thread?
Are you able to move this thread?