im not sure why this host has ping as service instead host check but either way it shouldnt alert.
output:
grep -i 'win_sql_server' /usr/local/nagios/var/nagios.log | perl -pe 's/(\d+)/localtime($1)/e'
[Fri Aug 10 00:00:00 2018] CURRENT HOST STATE: win_sql_server;UP;HARD;1;OK - 10.226.165.51: rta 122.255ms, lost 0%
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;CPU Usage 80/90;OK;HARD;1;CPU Load 0% (5 min average)
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;Drive C: Disk Usage 80/95;OK;HARD;1;C:\ - total: 39.66 Gb - used: 25.53 Gb (64%) - free 14.12 Gb (36%)
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;Drive E: Disk Usage 90/95;OK;HARD;1;E:\ - total: 40.00 Gb - used: 32.26 Gb (81%) - free 7.74 Gb (19%)
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;Memory Usage 90/95;OK;HARD;1;Memory usage: total:17262.92 MB - used: 14687.72 MB (85%) - free: 2575.21 M/usr/local/nagios/bin/nagios -VB (15%)
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;NSClient Status;OK;HARD;1;OK: All services are in their appropriate state.
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;Ping;OK;HARD;1;OK - 10.226.165.51: rta 122.237ms, lost 0%
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;SQL Core Services;OK;HARD;1;sqlserveragent: Started - mssqlserver: Started
[Fri Aug 10 00:00:00 2018] CURRENT SERVICE STATE: win_sql_server;Uptime;OK;HARD;1;System Uptime - 272 day(s) 5 hour(s) 15 minute(s)
[Fri Aug 10 13:14:59 2018] HOST DOWNTIME ALERT: win_sql_server;STARTED; Host has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;CPU Usage 80/90;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;Drive C: Disk Usage 80/95;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;Drive E: Disk Usage 90/95;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;Memory Usage 90/95;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;NSClient Status;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:14:59 2018] SERVICE DOWNTIME ALERT: win_sql_server;Ping;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:15:00 2018] SERVICE DOWNTIME ALERT: win_sql_server;SQL Core Services;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 13:15:00 2018] SERVICE DOWNTIME ALERT: win_sql_server;Uptime;STARTED; Service has entered a period of scheduled downtime
[Fri Aug 10 14:25:30 2018] SERVICE ALERT: win_sql_server;Ping;CRITICAL;SOFT;1;CRITICAL - 10.226.165.51: rta 650.163ms, lost 0%
[Fri Aug 10 14:27:30 2018] SERVICE ALERT: win_sql_server;Ping;CRITICAL;HARD;3;CRITICAL - 10.226.165.51: rta 672.770ms, lost 0%
[Fri Aug 10 14:32:24 2018] SERVICE NOTIFICATION: prod_sql;win_sql_server;Ping;OK;notify-service-by-email;OK - 10.226.165.51: rta 122.226ms, lost 0%
[Fri Aug 10 14:32:24 2018] SERVICE ALERT: win_sql_server;Ping;OK;HARD;1;OK - 10.226.165.51: rta 122.226ms, lost 0%
/usr/local/nagios/bin/nagios -V
Nagios Core 4.4.1
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2018-06-25
License: GPL
Website:
https://www.nagios.org
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License version 2 as
published by the Free Software Foundation.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.