AX1745
Axiom.EmailMessage
The Axiom.EmailMessage system table contains recent email messages generated by Axiom Software. This includes:
-
Queued email messages awaiting processing. The presence of emails in this queue automatically triggers the System.SMTPMessageDelivery job to be run, so under normal circumstances messages do not remain in the queue for long.
-
Email messages that have been processed by the System.SMTPMessageDelivery job. This means that the emails were delivered unless an error occurred.
-
Email messages that have been flagged as blocked and will not be delivered.
Messages remain in this table until they have been purged by the System.SystemDataPurge job. By default, all messages older than 15 days are purged, but this value is configurable.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
EmailMessageID |
The system-generated ID of the email message. |
|
ToAddress |
The To email addresses for the message. |
|
CCAddress |
The CC email addresses for the message. |
|
BCCAddress |
The BCC email addresses for the message. |
|
FromAddress |
The From email address for the message. |
|
Subject |
The subject text of the message. |
|
PlainTextBody |
The body text of the message. |
|
IsBlocked |
Whether the email message is blocked (True/False). If your organization has specified one or more allowed domains in the system configuration setting EmailDistributionAllowedDomain list, then all recipients of the email must match one of these allowed domains in order to send the email. If any of the recipients do not match the list, then the email is flagged as blocked and is not sent. If the EmailDistributionAllowedDomain list is blank, then all email recipients are allowed and no emails will be blocked. |
|
CreatedDTM |
The date the email message was created. |
|
DeliveryDTM |
The date the email message was processed by the System.SMTPMessageDelivery job. This field is blank if the email is in the queue awaiting processing, or if the email is flagged as blocked. |
Remarks
Only administrators can view the data in this table. Queries to this table by non-administrators return nothing.
Save Type 4 support
Axiom.EmailMessage cannot be modified using Save Type 4.
