How to export Exim Mail Delivery Reports on cpanel server

We are sending news letter to our customers twice in a week and my manager ask me to send Mail Delivery Reports, such as Successful,Deferrals & Failures list of email id, time and reason for failure. I throughly checked in WHM and i can view the report but there is no option to export the list which my manager expected. What we do ? We can export this Report from phpMyAdmin using eximstats database.

How to do that ?

Log into WHM as root, then go to Home >> SQL Services >> phpMyAdmin. Select the database eximstats >> Choose the corresponding table >> Export >> Choose the format and hit GO

Step:1

Log into WHM as root >> Home >> Email >> View Sent Summary and See the sent summary report in WHM.
how-to-export-exim-mail-delivery-reports-on-cpanel-server-1

Step:2

Click any of the one hyper-link. Like, Faliure and See the detailed report in WHM. It will load from Home >> Email >> Mail Delivery Reports.
how-to-export-exim-mail-delivery-reports-on-cpanel-server-2

Step:3

Home >> SQL Services >> phpMyAdmin and it will open the phpMyAdmin in new page >> Select the database eximstats >> Choose the corresponding table >> SQL >> In my case i want to export only three column. So I’m going to use custom MySQL query (see below) >> GO that’s it. It will generate the report which you expected.

# select mailtime,email,message FROM `failures` where mailtime between '2014-08-07 01:10:10' and '2014-08-07 11:45:10'

a) MySQL query snap shot


how-to-export-exim-mail-delivery-reports-on-cpanel-server-3

b) Query Output snap shot


how-to-export-exim-mail-delivery-reports-on-cpanel-server-5

Step:4

phpMyAdmin >> Export >> Choose “CSV of MS Excel” >> GO that’s it. It will export and downloaded to your PC. See below.
how-to-export-exim-mail-delivery-reports-on-cpanel-server-4
See below both file has been downloaded in my PC.

# ls -lht
total 5.2M
-rw-rw-r--  1 magesh magesh 3.7M Aug 13 14:51 failures.csv
-rw-rw-r--  1 magesh magesh 1.5M Aug 13 14:50 defers.csv

We are preparing all articles in-depth to understand by all level/stage Linux administrators. If the article is useful for you, then please spend less than a minute to share your valuable comments in our commenting section.

Please stay tune with us…Good Luck.

Magesh Maruthamuthu

Love to play with all Linux distribution

You may also like...