report.sh
#!/bin/bash
yesterday=$(date +"%Y-%m-%d" -d -7day)
today=$(date +"%Y-%m-%d")
logs=$(zcat /var/log/jitsi/jicofo.log.*.gz | cat - /var/log/jitsi/jicofo.log.1 /var/log/jitsi/jicofo.log | awk '$2>=from && $2<=to' from="$yesterday" to="$today" | grep "joined." | wc -l )
rooms=$(zcat /var/log/jitsi/jicofo.log.*.gz | cat - /var/log/jitsi/jicofo.log.1 /var/log/jitsi/jicofo.log | awk '$2>=from && $2<=to' from="$yesterday" to="$today" | grep "Created new conference" | wc -l)
logins=$(zcat /var/log/jitsi/jicofo.log.*.gz | cat - /var/log/jitsi/jicofo.log.1 /var/log/jitsi/jicofo.log | awk '$2>=from && $2<=to' from="$yesterday" to="$today" | grep "Authentication session created for" | wc -l)
swaks --to mail@example.com --from "noreply@henningklatt.de" --server smtp.example.com --auth LOGIN --auth-user "noreply@henningklatt.de" --auth-password "password" --tls-on-connect --port 465 --header "Subject: Jitsi Nutzerstatistik von $(date +"%e. %b %T" -d -7day) bis $(date +"%e. %b %T")" --body "Jitsi Benutzer: $logs \n Erstellte Räume: $rooms \n Angemeldete (registrierte) Benutzer: $logins"
TOKEN="Telegram-bot-token"
ID="chat-id"
URL="https://api.telegram.org/bot$TOKEN/sendMessage"
curl -s -X POST $URL -d chat_id=$ID -d text="$Jitsi Benutzer: $logs %0AErstellte Räume: $rooms %0AAngemeldete (registrierte) Benutzer: $logins"
crontab -e
15 0 * * MON /root/report.sh >> /root/report.log