Home > Forum > Database > Reports mails

Reports mails
0

How to check all the emails that are in our systems ? If i use the WFMails than we see the ones that are currently being sent right? But how to get the data from the all emails that we sent in general?

MVP

Hi,

the table contains all the available mail information.
- Going to be sent
- Sent
- Errored

Since there can be a whole bunch of mails these are removed during the database maintenance hours:
Database maintenance hours

During database service hours, tables are cleared in the following order:
...
12. WFMails - 100000 entries with the "Sent" status and older than 30 days
...
Tables are cleaned one by one using the queue algorithm. Once a table is selected, the maximum number of rows allowed by the TOP statement
is deleted. If there are still rows remaining in the table, it is once again marked for cleaning and placed at the end of the queue.

Best regards,
Daniel