- 论坛徽章:
- 8
|
本帖最后由 zl624867243 于 2018-07-17 16:38 编辑
回复 5# wh7211
通过跑定时任务每分钟执行然后清空数据表的方案可行,但是我要的结果是这样按info相同的进行归类,按你的方式我把脚本和sql语句做了如下更改,
- mysql -uxx -poo<<EOF>1.txt
- use agg_zabbix;
- SELECT message FROM agg_zabbix.agg_alerts WHERE sendto='123@qq.com' AND message LIKE '%PROBLEM' OR message LIKE '%ok' ORDER BY clock;
- EOF
复制代码 1.txt 文件如下:
- message
- ALY-HN1_Black-web-PRD-2,10.18.25.169,2018.07.16,16:54:06,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-4,10.18.25.184,2018.07.16,16:54:08,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-1,10.18.1.234,2018.07.16,16:54:14,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-3,10.18.1.248,2018.07.16,16:54:15,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-2,10.18.25.169,2018.07.16,16:59:08,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-4,10.18.25.184,2018.07.16,16:59:10,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-1,10.18.1.234,2018.07.16,16:59:14,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-3,10.18.1.248,2018.07.16,16:59:16,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- 2018.07.16,17:00:08,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-2,10.18.25.169,OK
- 2018.07.16,17:00:11,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-4,10.18.25.184,OK
- 2018.07.16,17:00:16,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-3,10.18.1.248,OK
- ALY-HN1_Black-web-PRD-1,10.18.1.234,2018.07.16,17:37:18,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-3,10.18.1.248,2018.07.16,17:37:20,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-2,10.18.25.169,2018.07.16,17:38:10,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- ALY-HN1_Black-web-PRD-4,10.18.25.184,2018.07.16,17:38:11,Warning,black request time avg above 3000ms,site_huolala_time_avg[black],black avg time per min,PROBLEM
- 2018.07.16,17:39:18,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-1,10.18.1.234,OK
- 2018.07.16,17:39:21,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-3,10.18.1.248,OK
- 2018.07.16,17:40:10,black request time avg above 3000ms,ALY-HN1_Black-web-PRD-2,10.18.25.169,OK
- 2018.07.17,15:48:38,Cpu idle time le 50 percent,ALY-HN1_das_daemon-vpc,10.18.25.220,OK
复制代码 按你的awk脚本格式不对,(对host,ip,time 进行聚合操作),聚合的原则是info和status 相同的归为一类 ,我想要的结果如下:
- host: ALY-HN1_Black-web-PRD-1,ALY-HN1_Black-web-PRD-2,ALY-HN1_Black-web-PRD-3
- ip: 10.18.1.234,10.18.25.169,10.18.1.248
- time: 2018.07.16-14:32:38,2018.07.16-14:32:39,2018.07.16-14:32:40
- info: black request time avg above 3000ms
- status: PROBLEM
复制代码
|
|