Video instructions for MailServer Stats

Some useful postfix commands

//postqueue -p is the same as mailq
List mail queue and MAIL_ID's, list mail queue
postqueue -p

Reload config
service postfix reload

Restart postfix server
service postfix restart

View the postfix version
postconf mail_version

Show default postfix values
postconf -d

Show non default postfix values
postconf -n

Flush mail queue
postfix flush

Process the queue now
postqueue -f

Process all emails stuck in the queue
postsuper -r ALL && postqueue -f

Read email from mail queue
postcat -q MAIL_ID

To remove MAIL_ID mail from the queue
postsuper -d MAIL_ID

To remove all mail from the queue
postsuper -d ALL

To remove all from mail queue FAST
find /var/spool/postfix/deferred/ -type f | xargs -n1 basename | xargs -n1 postsuper -d

To remove all mails in the deferred queue
postsuper -d ALL deferred

Sort and count emails by "from address"
postqueue -p | awk '/^[0-9,A-F]/ {print $7}' | sort | uniq -c | sort -n

Removing all emails sent by:
postqueue -p|grep '^[A-Z0-9]'|grep|cut -f1 -d' '|tr -d \*|postsuper -d -

Remove all email sent from
postqueue -p|awk '/^[0-9,A-F].* / {print $1}'|cut -d '!' -f 1|postsuper -d -

Remove all email sent by domain
postqueue -p | grep '^[A-Z0-9]'|grep|cut -f1 -d' ' |tr -d \*|postsuper -d -

Mail queue stats short
postqueue -p | tail -n 1

Number of emails in Mail queue
postqueue -p | grep -c "^[A-Z0-9]"

Fast count of emails in mail queue
find /var/spool/postfix/deferred -type f | wc -l

Watch Log Live
tail -f /var/log/maillog

Count and sort success pop3/imap logins

grep "\-login"  /var/log/dovecot-info.log |grep "Login:"|awk {'print $7'}|sort|uniq -c|sort -n

Count and sort success SMTP postfix logins (useful for tracking spammer)

grep -i "sasl_username"  /var/log/maillog |awk {'print $9'}|sort|uniq -c|sort -n

Count and sort success SMTP postfix logins on exact date "Jun 18"

grep -i "sasl_username"  /var/log/maillog |grep "Jun 18"|awk {'print $9'}|sort|uniq -c|sort -n

Analyze Postfix Logs

pflogsumm /var/log/maillog | less

** If you don't have pflogsumm then you can install this rpm package "postfix-perl-scripts".