#!/bin/sh

# Show usage of meet-lug-stormarn.de according to Apache access logfile
# with number of participants per jitsi-meeting-room

cat /var/log/apache2/meet.lug-stormarn.de_access.log |grep "room="|grep POST |cut -f1,7 -d\ |sort -k2 |uniq|cut -f2 -d\ |cut -f2 -d=|uniq -c | column -t | tr -s [:space:] | datamash -t' ' -f sha1 2 | cut -f1,3 -d\