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.
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.
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
b) Query Output snap shot
Step:4
phpMyAdmin >> Export >> Choose “CSV of MS Excel” >> GO that’s it. It will export and downloaded to your PC. See below.
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.
