Tracking center export to file

K

khangnch

New Member
May 28, 2022
16
1
3
Hi.

I just want to ask if there is any way to export mail log at tracking center to a .pdf or .xlsx file.

I want to print the mail log for some auditing reasons.

Thank you.
 
Hi,

currently there isn't natively, but it seems sensible to have at least and CSV export, as that then can be imported to any spreadsheet software quite easily.

Opening a view (iframe or second tab) with a for print optimized style sheet could be a possible (relatively) simple option to get a PDF export, as most modern browser support printing a page to PDF.

Please open an enhancement request for this over at https://bugzilla.proxmox.com/ (please add a link this forum thread).

FWIW, as workaround you could use the CLI directly for now for a simple text output which you could process further to your desired format, check pmg-log-tracker --help for a CLI option overview.
 
@t.lamprecht
Any news on this?

Today i had the issue that i needed to export a list of all mails between two timestamps and for multiple domains.
A customer had an hardware failure and lost about two hours worth of mails, because their backup was too old.
He wanted to have a list of mails between the backup time and the outage to be able to contact their customers so that they can resend that lost mail.

As of right now i copy and pasted this from the pmg webinterface -> trackingcenter into an excel sheet which had issues. For example the timecode from the first row was not imported correctly.

Mär 12 13:39:10renate.***@****.deD.****@***.deaccepted/delivered

would change to the following when copied to excel:
01.03.2012 13:39renate.***@****.deD.****@***.deaccepted/delivered

Also you are not able to select the top, scroll down and copy the whole thing. It needs to be done in chunks which is not very helpful if there are a lot of mails.

It would be awesome if their would be a button to export the current selection from the tracking center to a csv file. Maybe even with multiple domains selected in the TO field.


As for your workaround:
Input:
Code: 
pmg-log-tracker -s "2024-03-12 12:00:00" -e "2024-03-12 13:40:00" -t @DOMAIN  -n
Output:
Code: 
TO:65F05AFE:E01C710189C:P: from <renate.***@****.de> to <D.****@***.de> (IP[IP]:25)

No timecode or status of the mail to be seen. This is suboptimal.


Thanks for your time.
 
  • Like
Reactions: ijurisic
Not gonna lie, this would come in handy if there was a way to do a CSV export. Unfortunately as crz mentioned, the CLI does show the track log, but does not show the "Status". Otherwise it would be easy to pipe that output into a file and do some regex to fix it up.
 
  • Like
Reactions: hilocz
Salut,

Betreffend des Problems wurde dies folgendermassen gelöst:

Rohdaten via SSH zu Proxmox Mail Gateway exportieren --> Als Beispiel diese ZeitRange:

Code: 
pmg-log-tracker -s "2026-02-17 00:00:00" -e "2026-02-24 23:59:59" -v -n -g > /tmp/raw.txt
Den Parse-Script erstellen in der SSH Verbindung:

Code: 
cat > /tmp/parse.py << 'EOF'
import re, csv, datetime
entries = []
current = None
with open('/tmp/raw.txt') as f:
    for line in f:
        line = line.rstrip()
        if line.startswith('QENTRY:') or line.startswith('SMTPD:'):
            if current and current.get('to'):
                entries.append(current)
            current = {'timestamp':'','from':'','to':'','status':'','size':'','client':'','msgid':''}
        elif current is not None:
            if line.startswith('CTIME:'):
                try:
                    ts = int(line.split(':',1)[1].strip(), 16)
                    current['timestamp'] = datetime.datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')
                except: pass
            elif line.startswith('SIZE:'):
                current['size'] = line.split(':',1)[1].strip()
            elif line.startswith('CLIENT:'):
                current['client'] = line.split(':',1)[1].strip()
            elif line.startswith('MSGID:'):
                current['msgid'] = line.split(':',1)[1].strip().strip('<>')
            elif line.startswith('TO:'):
                parts = line.split(':', 4)
                if len(parts) >= 4:
                    code = parts[3].strip()
                    if code in ('A','P','2'): current['status'] = 'allowed'
                    elif code in ('B','N'): current['status'] = 'blocked'
                    elif code == 'Q': current['status'] = 'quarantine'
                    elif code in ('G','D','4'): current['status'] = 'greylisted'
                    elif code == '5': current['status'] = 'failed'
                    else: current['status'] = code
                m = re.search(r'from <([^>]*)> to <([^>]*)>', line)
                if m:
                    current['from'] = m.group(1)
                    current['to'] = m.group(2)
if current and current.get('to'):
    entries.append(current)
entries.sort(key=lambda x: x['timestamp'])
counts = {}
for e in entries:
    counts[e['status']] = counts.get(e['status'], 0) + 1
with open('/tmp/ipa_mail_report.csv', 'w', newline='') as f:
    w = csv.writer(f, delimiter=';')
    w.writerow(['timestamp','from','to','status','size','client','msgid'])
    for e in entries:
        w.writerow([e['timestamp'], e['from'], e['to'], e['status'], e['size'], e['client'], e['msgid']])
print(f"{len(entries)} Mails exportiert")
for k in sorted(counts):
    print(f"  {k}: {counts[k]}")
if entries:
    print(f"Zeitbereich: {entries[0]['timestamp']} bis {entries[-1]['timestamp']}")
EOF


Script ausführen:
Code: 
python3 /tmp/parse.py

Dann Inhalt prüfen:
Code: 
head -5 /tmp/ipa_mail_report.csv
Auf einer anderen Powershell Instanz die SSH Verbindung öffnen und diesen Befehl ausführen:

Code: 
scp -i "SSH Verbindungsart" root@>eureIP<:/tmp/ipa_mail_report.csv C:\temp\ipa_mail_report.csv

Anmerkung: Der Pfad auf dem Ihr dies exportiert muss zuvor schon existieren.

Beste Grüsse:cool:,
Giolden
 
Last edited:
You must log in or register to reply here.
Top Bottom
Back