Script to notify when a large number of alerts are detected

more_than_alerts.sh

#!/bin/bash
#
# File: more_than_alerts.sh
# Release Version : 1.0
# Created 2019/07/16
# Licens: MIT
# Auther t.saito@infraya.jp
# How to use:
# For zabbix server
#   "chmod + x" and please add on your scripts directory.
#     e.g. /etc/zabbix/scripts/more_than_alerts.sh
#   mkdir /etc/zabbix/tmp/
#   chown zabbix:zabbix /etc/zabbix/tmp/
#  Please execute manually for the first time.
#   bash /etc/zabbix/scripts/more_than_alerts.sh
# For Zabbix Agent Config
#   UserParameter=MoreThanAlerts.key,/etc/zabbix/script/more_than_alerts.sh [MySQL username] [MySQL password]
# For Zabbix item
#   MoreThanAlerts.key
#
##################################
# Base Infomation
##################################
# Settings

##################################
# Zabbix
##################################
# Filecheck
if [[ ! -e /etc/zabbix/tmp/alerts.tmp ]]; then
    /usr/bin/touch /etc/zabbix/tmp/alerts.tmp
fi

# Get data from alerts table
ALERTS=`/usr/bin/mysql -u $1 -p$2 -ss -e "select count(*) from zabbix.alerts;"`
# Get last time data
OLDALERTS=`cat /etc/zabbix/tmp/alerts.tmp`
# Check the difference
NUMALERTS=`echo $(($ALERTS-$OLDALERTS));`

# For next check
echo $ALERTS > /etc/zabbix/tmp/alerts.tmp

# Show results
echo $NUMALERTS

exit