Tracking center export to file

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.
 
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

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!