zabbix_server.conf 修改

zabbix_server.conf 增加用户自定义参数：

UserParameter= test.query[*],/zabbix/bin/test01_to.sh $1 $2

 

/zabbix/bin

test01_to.sh: 

 SQL="use "$2";  SELECT TIMESTAMPDIFF(SECOND, min(C_DATE), NOW()) AS 'D_TIME' FROM table_01 where id = \""$1"\" ;"

User = $(mysql -tedb -p123456 -hlocalhost -s -e "${SQL}")

#echo 'SQL='$SQL
echo $User
 

[root@zabbix_server etc]# vim zabbix_agentd.conf
[root@zabbix_server etc]# /etc/init.d/zabbix_agentd restart     #重启 agentd
Stopping Zabbix Agent:                                     [  OK  ]
Starting Zabbix Agent:                                     [  OK  ]
[root@zabbix_server etc]#