Skip to content

I want to check the email sending log of Pleasanter

Answer

Please refer to the "OutgoingMails table".

Overview

These are the steps to obtain the "email sending log" of Pleasanter. Pleasanter's email sending log is stored in the "OutgoingMails table" in the "database".

Notes

  1. This procedure involves direct manipulation of the database, so it is risky. It is strongly recommended that you make a "Backup" beforehand.

Operation Procedure

  1. Log in to the server where Pleasanter is installed.
  2. Start a tool that can connect to the database, such as Azure Data Studio.
  3. Execute the following SQL to get data from the "OutgoingMails table".

Sample code

SQL（to get the most recent 1000 items）
select top 100 * from "OutgoingMails" order by "OutgoingMailId" desc;
SQL（to get logs for a specific period）
select top 100 * from "OutgoingMails" where "CreatedTime" between '2021/09/25 00:00:00' and '2021/09/26 00:00:00' order by "OutgoingMailId" desc;

Log Contents

The contents of the "OutgoingMails table" are as follows.

  1. Host：The destination host.
  2. Port：The destination port.
  3. From：The From address of the email sender.
  4. To：The To address of the email recipient.
  5. Cc：The Cc address of the email recipient.
  6. Bcc：The Bcc address of the email recipient.
  7. Title：The subject of the email.
  8. Body：The body of the email.
  9. SentTime：The date and time the email was sent.
  10. Comments：This column is unused.
  11. Creator：If the user is logged in, this indicates the user ID. The user name must be linked to the Users table to confirm.
  12. Updator：Same as above.