我有很多类似这样的nagios记录，时间是从0点0分0秒 到 23:59:59
关键字是 DOWN WARNING CRITICAL，有这些字样的记录就会发出告警短信。
[Sun Apr 13 12:47:09 2014] HOST ALERT: check_North;DOWN;SOFT;1;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:10 2014] HOST ALERT: 242.103;DOWN;HARD;2;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:10 2014] HOST NOTIFICATION: xiaofei;242.103;DOWN;notify-host-by-email;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:13 2014] HOST ALERT: dx-144.23;DOWN;SOFT;1;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:13 2014] HOST ALERT: 242.109;DOWN;SOFT;1;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:16 2014] HOST ALERT: IIS242.209;DOWN;SOFT;1;(Host check timed out after 30.00 seconds)
[Sun Apr 13 12:47:17 2014] HOST ALERT: 242.220;DOWN;SOFT;1;(Host check timed out after 30.00 seconds)
[Sun Apr 13 15:15:41 2014] SERVICE ALERT: dx-144.8;checkPro-hqc;WARNING;SOFT;1;No data was received from host!
[Sun Apr 13 18:57:48 2014] SERVICE ALERT: IIS242.240;checkping;WARNING;SOFT;1;PING WARNING - Packet loss = 60%, RTA = 46.90 ms
[Sun Apr 13 18:57:51 2014] SERVICE ALERT: 242.103;checkping;WARNING;SOFT;1;PING WARNING - Packet loss = 50%, RTA = 41.30 ms
[Sun Apr 13 18:57:52 2014] SERVICE ALERT: 242.110;checkping;WARNING;SOFT;1;PING WARNING - Packet loss = 50%, RTA = 40.53 ms
[Sun Apr 13 18:58:14 2014] SERVICE ALERT: 242.109;check-host-alive;WARNING;SOFT;1;PING WARNING - Packet loss = 81%, RTA = 43.89 ms
[Sun Apr 13 18:58:15 2014] SERVICE ALERT: dx-144.8;check-c-disk;WARNING;SOFT;1;No data was received from host!
[Sun Apr 13 18:58:32 2014] SERVICE ALERT: 242.103;checkping;WARNING;SOFT;2;PING WARNING - Packet loss = 70%, RTA = 42.57 ms
[Sun Apr 13 18:58:33 2014] SERVICE ALERT: 242.110;checkping;WARNING;SOFT;2;PING WARNING - Packet loss = 80%, RTA = 44.41 ms
[Sun Apr 13 18:58:38 2014] SERVICE ALERT: js-144.28;checkPro-hqc;WARNING;SOFT;1;No data was received from host!
[Sun Apr 13 18:58:52 2014] SERVICE ALERT: IIS242.209;checkCPU;WARNING;SOFT;2;could not fetch information from server
[Sun Apr 13 18:58:55 2014] SERVICE ALERT: IIS242.240;check-host-alive;WARNING;SOFT;1;PING WARNING - Packet loss = 81%, RTA = 43.90 ms
[Sun Apr 13 18:58:06 2014] SERVICE ALERT: 242.108;check6501;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:07 2014] SERVICE ALERT: dx-144.23;CheckHqservice;CRITICAL;HARD;1;Using service TCP
[Sun Apr 13 18:58:07 2014] SERVICE ALERT: dx-144.12;check-d-disk;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:10 2014] SERVICE ALERT: js-144.28;CheckHqservice;CRITICAL;HARD;1;Using service TCP
[Sun Apr 13 18:58:10 2014] SERVICE ALERT: dx-144.12;check-c-disk;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:15 2014] SERVICE ALERT: js-144.28;checkCPU;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:16 2014] SERVICE ALERT: dx-144.12;checkPro-hqc;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:17 2014] SERVICE ALERT: dx-144.23;checkCPU;CRITICAL;SOFT;1;CRITICAL - Socket timeout after 30 seconds
[Sun Apr 13 18:58:19 2014] SERVICE ALERT: 242.108;check cpu load;CRITICAL;SOFT;1;CHECK_NRPE: Socket timeout after 10 seconds.
[Sun Apr 13 18:58:23 2014] SERVICE ALERT: dx-144.23;check-c-disk;CRITICAL;HARD;2;Connection timed out
[Sun Apr 13 18:58:26 2014] SERVICE ALERT: dx-144.8;checkPro-hqc;CRITICAL;SOFT;1;Connection timed out
[Sun Apr 13 18:58:30 2014] SERVICE ALERT: dx-144.23;checkCPU;CRITICAL;HARD;2;Connection timed out
[Sun Apr 13 18:58:31 2014] SERVICE ALERT: dx-144.7;check-c-disk;CRITICAL;HARD;2;Connection timed out
[Sun Apr 13 18:58:35 2014] SERVICE ALERT: dx-144.8;CheckHqservice;CRITICAL;HARD;1;Using service TCP
我的需求是：
我想分时间段（最好自己能定义例如: 09:00:00~13:15）统计一下分别有多少次 DOWN 和 WARNING 和 CRITICAL，最好结果能导入到xls表格。
谢谢