exiqgrep & exigrep

exiqgrep & exigrep

exigrep searches the log, while exiqgrep is exim queue grep. See the table which has the link to the documentation as well.


    52.2 exiqgrep grep the queue
    52.3 exiqsumm summarize the queue
    52.4 exigrep grep search the main log


Exiqgrep Options & Usages

Options                 What is the option for            Usage

-i                         list the message IDs                    exiqgrep -i
-z                         show frozen messages                exiqgrep -z
-x                             show unfrozen messages            exiqgrep -x
-f                         match the sender address  exiqgrep -f beserk2@server1.beserk.com.au
-r                         match the recipient address     exiqgrep -r update_profile@westpac.com.au
-c                         count the matching results exiqgrep -c -r update_profile@westpac.com.au
-o                            older than a number of seconds   exiqgrep -o 43000
-y                        younger than a number of seconds / to get the latest emails exiqgrep -y 3600




Examples

exiqsumm
============================================
root@server1 [/dev]# exim -bp | exiqsumm
Count  Volume  Oldest  Newest  Domain
-----  ------  ------  ------  ------
    1    6144     66h     66h  abigroup.com.au
    2    11KB     44h     44h  optusnet.com.au
    6    30KB     59h     17h  westnet.com.au
    1    12KB      9h      9h  westpac.com.au
---------------------------------------------------------------
   10    60KB     66h      9h  TOTAL
=================================================

exiqgrep
========================================================
root@server [~/cmq]# exiqgrep -i -f  gpconsults1@datafull.com | xargs exim -Mrm
Message 1U6n95-0000nm-N7 has been removed
========================================================

exigrep
=========================================================
root@server [~/cmq]# exigrep gpconsults1@datafull.com /var/log/exim_mainlog |more

2013-02-17 05:36:10 1U6rlh-0007MG-DE <= <> R=1U6nGB-0005et-Th U=mailnull P=local
 S=3728 T="Mail delivery failed: returning message to sender" for gpconsults1@da
tafull.com
2013-02-17 05:36:19 1U6rlh-0007MG-DE => gpconsults1@datafull.com R=dkim_lookupho
st T=dkim_remote_smtp H=proxymail1.sion.com [200.81.186.15]
2013-02-17 05:36:19 1U6rlh-0007MG-DE Completed
===============================================================


Information to be noted
While running any of the below commands, if you are getting a message saying "exim: no message ids given after -Mrm option" , that means that there are not messages / emails matching your search condition. This can be ignored or investigated properly. It could be even that the command is wrong.

Exim Manual
Exim don't have a man page installed in your system to check more about the command line options like -b, -p, -r, -c etc. You will have to go to the Documentation link at http://www.exim.org/exim-html-current/doc/html/spec_html/ch-the_exim_command_line.html to know more about exim and its options.


Listing all the emails in the queue

List all the emails

#exim -bpr | more
Output will be similar to below

Output of exim -bpr

8h  3.7K 1U6mtp-0005IO-0B <>
          gpconsults1@datafull.com

11h  2.4K 1U6kDp-00069W-J1 <johnsondavidd01@yahoo.co.jp>
          bfee@mysmtpmail.com
        D bfiocca@verizon.net
          bfjink@sbcglobal.net
        D bflegalaid1@verizon.net
          bflower@maildomination.com
        D bfmatic@hotmail.com
        D bfontaine@myexcel.com
          bford7@aol.com
        D bfranton@verizon.net
        D bfthorne@cox.net
          bftrettin@sbcglobal.net
          bg2bump2749@sbcglobal.net
          bg_kici@sbcglobal.net
          bgbales@sbcglobal.net
          bgelsky@sbcglobal.net
        D bgg2@verizon.net
        D bggyltgls@cox.net
          bghoogland@sympatico.ca
        D bgj38@gvtc.com
        D bgkaasa@charter.net
          bglass411@sbcglobal.net


Removing a email based on a from address
In the above example, if I have to remove the mails from johnsondavidd01@yahoo.co.jp, use the command below

exiqgrep -i -f  johnsondavidd01@yahoo.co.jp | xargs exim -Mrm


Remove an email based on to address
In the above example, if I have to remove the mails to gpconsults1@datafull.com, use the command below


exiqgrep -i -r gpconsults1@datafull.com  | xargs exim -Mrm

Count the the maximum no of email currently in the mail queue which have from or to email address in the mail queue

exim -bpr | grep "<*@*>" | awk '{print $4}' | grep -v "<>" | sort | uniq -c | sort -n

Delete all messages containing or matching a certain string in the body of the email
This can be used to remove the bounce back emails, recipient cannot be verified mails, Mailer Daemon emails etc.


Example : Here the string is "X-Mailer"
root@server1 [/var/spool/exim/input/]# grep -lr 'X-Mailer' /var/spool/exim/input/ | sed -e 's/^.*\/\([a-zA-Z0-9-]*\)-[DH]$/\1/g' | xargs exim -Mrm


You may even use the below commands to remove the bounced messages. This is based on the logic that the from email address is empty on bounced / mail delivery failed messages.



root@server [~/cmq]#  exiqgrep -i -f '<>'  | xargs exim -Mrm
Message 1U6wOe-0000TX-W4 has been removed


Delete all the emails from the queue

It is NOT RECOMMENDED to delete all the emails from mail queue, unless you are pretty sure that all the emails including the emails just came to the customer or send out by a customer can be deleted as well.

root@server1 [/var/spool/exim/input/]# exiqgrep -i | xargs exim -Mrm

Count all messages in queue

root@server [~]# exim -bpc
1


Summarize the queued email messages, grouped by recipient address

root@server1 [~]# exim -bpr | grep -Eo "^\s*[^ ]*@[^ ]*$" | sort | uniq -c
      1           gbay@westnet.com.au
      3           kathleenclayton@westnet.com.au
      1           kelinlee@optusnet.com.au
      2           monokuroboo@westnet.com.au
      1           psaffery@optusnet.com.au
      1           Samantha.court@abigroup.com.au
      1           update_profile@westpac.com.au


Summarize the queued email messages, grouped by sender address


root@server1 [~]# exim -bpr | grep -Eo "<[^ ]*@[^ ]*>" | sort | uniq -c
     10 <beserk2@server1.beserk.com.au>

Remove all the emails older than 12 hours

Remove all the emails older than 12 hours (43000 secs)
root@server1 [~]# exiqgrep -o 43000 -i | xargs exim -Mrm