#!/bin/bash

HOURS=12

CHRBIN=/usr/sbin/chroot
CHRDIR=/chroot/admin

function qkeylist()
{
	if [ -S $CHRDIR/run/mysqld/mysqld.sock ]; then
		echo "SELECT qt.TrackKey
			FROM quotas_tracking qt LEFT JOIN quotas_limits ql ON qt.QuotasLimitsID=ql.id
			WHERE qt.Counter > 20
			AND from_unixtime(qt.LastUpdate) > DATE_ADD(NOW(), INTERVAL -${HOURS} HOUR)
			ORDER BY qt.Counter DESC, qt.LastUpdate DESC;" | \
		$CHRBIN $CHRDIR mysql \
		--defaults-file=/etc/mysql/debian.cnf \
		--socket=/run/mysqld/mysqld.sock \
		-ss -n sys_cluebringer
	fi
}

qkeys=`qkeylist`

for qkey in $qkeys; do

	echo "${qkey}"
	grep 'cbpolicyd\[' /var/log/syslog |grep 'reason=quota_update' |grep "${qkey}" |awk '{print $3 " " $8 " " $9 " " $10 " " $11 " " $18 " " $19}' #|sort -n -k 6
	echo

done