Category:Email

Users that have logged into the IMAP server today

grep "imap-login: Login: user=<" /var/log/maillog |grep "`date +%b' '%d`" |awk '{ print $8 }' |sort |uniq -c

Messages blocked by SPF today

grep spf /var/log/maillog |grep reject |grep "`date +%b' '%d`" |wc -l

• Users who have logged into imap in the last 15 minuets

echo "select user, last_login, last_IP from user_meta where last_login > DATE_SUB(NOW(), INTERVAL 15 minute);" |mysql postfix -t