Nagios/Icinga NRPE Monitoring Check for expiration date of a licens

[RIA-Ingo]

Hello,
maybe helpful for others:

#!/bin/bash

# Description:
# This script checks the expiration date of a license in the MySQL database “snipeit”.
# Exit code 0 = OK
# Exit code 1 = Warning

# Usage:
#   ./check_license.sh -n "Lizenzname with spaces" -d <Amount days>


while getopts "n:d:" opt; do
  case $opt in
    n) NAME="$OPTARG" ;;
    d) DAYS="$OPTARG" ;;
    *) echo "Usage: $0 -n <Name> -d <Tage>"; exit 1 ;;
  esac
done

if [[ -z "$NAME" || -z "$DAYS" ]]; then
  echo "Fehler: Bitte Name (-n) und Tage (-d) angeben."
  echo "Usage: $0 -n <Name> -d <Tage>"
  exit 1
fi

# --- MySQL access data ---
DB_USER="user"
DB_PASS="password"
DB_NAME="snipeit"
DB_HOST="localhost"


SQL_QUERY=$(printf "SELECT expiration_date FROM licenses WHERE name='%s' LIMIT 1;" "$NAME")
EXPIRATION_DATE=$(mysql -u"$DB_USER" -p"$DB_PASS" -h"$DB_HOST" -D"$DB_NAME" -sse "$SQL_QUERY")

if [[ -z "$EXPIRATION_DATE" ]]; then
  echo "Fehler: Keine Lizenz mit dem Namen \"$NAME\" gefunden."
  exit 1
fi

TODAY=$(date +%Y-%m-%d)
THRESHOLD_DATE=$(date -d "$TODAY +$DAYS days" +%Y-%m-%d)


if [[ "$EXPIRATION_DATE" < "$THRESHOLD_DATE" ]]; then
  # Lizenz läuft bald ab
  DAYS_LEFT=$(( ( $(date -d "$EXPIRATION_DATE" +%s) - $(date -d "$TODAY" +%s) ) / 86400 ))
  echo “WARNING: License \”$NAME\“ expires in $DAYS_LEFT days. Expiration date: $EXPIRATION_DATE”
  exit 1
else
  echo "License \"$NAME\" OK. Expiration date $EXPIRATION_DATE"
  exit 0
fi

`