1 Topic by bijuedathodi

  • bijuedathodi
  • Member
  • Offline
  • Registered: 2012-09-05
  • Posts: 71

Topic: Sent/Receive/quarantine Logs

Is it possible to export all sent receive quarantine mail status report to a CSV file from iRedadmin Pro on date wise basis?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,155

Re: Sent/Receive/quarantine Logs

Unfortunately, the latest iRedAdmin-Pro doesn't support this. Maybe we can write a script to export it, and run it with cron job.

You can also dump SQL tables to another database as a backup.

3 Reply by bijuedathodi (edited by bijuedathodi 2015-06-06 22:11:41)

  • bijuedathodi
  • Member
  • Offline
  • Registered: 2012-09-05
  • Posts: 71

Re: Sent/Receive/quarantine Logs

For testing i exported entire amavisd database on another mysql Server.
Used below query (provided by mir)

select * from msgrcpt left join msgs on msgs.mail_id = msgrcpt.mail_id left join maddr on msgrcpt.rid = maddr.id;       (thanks to Mir)

But this not shows status 'sent'
Only shows 'queued and Discarded' status. what happened to that mail after put into mailqueue is not clear.

i also tried to build an additional mailtracking database using postfix maillog, but Subject line is missing in postfix maillog,  status is showing in maillog.

Isit possible to include Subject line in postfix log? Will it make any problems


I need to backup these mail status reports atleast for one year in csv or using any other method (in Ired i have set for 7 days due to perfomance issues)

FYI, suceesfully cnfigd pflogsumm on ired (also sheduled on cron for sending  activity reports on daily basis  ), this includes errors & bounce reports.