: How to build a list from Postfix maillog I want to build a list from maillog, maillog.x containing something like Date, Sender's email, Recipient's Email and subject of the message filtering

@Si4351233

Try aillog-hashnize.pl from gist.github.com/xtetsuji/1446584 It is a perl script to parse maillog file and produce output file as CSV. Then import CSV into Excel and apply filter as you wish (@recipient.com).


perl maillog-hashnize.pl -y 2016 maillog-20160124 > maillog.csv

Vote Up Vote Down

@BetL925

You could try opening it with LibreOffice, It asks you for the separator when you open a CSV file. For that to work you would have to rename the file as maillog.csv so that LibreOffice knows that it is a CSV file.

I suspect that won't work well. Instead, I would get things in the right format with Unix command line tools first.

Use grep to only show the lines with a recipient that you are interested in:

grep -E 'to=[a-z]+@recipient.com'


Use sed to remove the parts of the line you don't need. Sed uses s/find/replace/g syntax. I would use four find and replaces like this:

sed -r 's/.*Subject: //g;s/ from .* from=/t/g;s/ to=/t/g;s/ proto=.*//g'


Putting it all together would be this command line:

cat maillog.x | grep -E 'to=[a-z]+@recipient.com' | sed -r 's/.*Subject: //g;s/ from .* from=/t/g;s/ to=/t/g;s/ proto=.*//g' > /tmp/maillist.csv


Then /tmp/maillist.csv would contain:

TESTING SUBJECT sender@sender.com> recipient@recipient.com>

Vote Up Vote Down