The lyrDeliveryAttemptLog is a log of all the individual connection attempts the ListManager makes. Typically only failures are logged
|
Field Name |
Description |
Version Added |
| MyIP | Integer value of the local IP address used for this delivery attempt (int NULL) | 10.0 |
| MXIP | Integer value of the remove IP address used for this delivery attempt (int NULL) | 10.0 |
| MailStreamID | The ID of the MailStream used for this delivery attempt (int NULL) | 10.0 |
| MemberLogId | ID of the related object from the table specified by InmailType, if any (int NULL) | 10.0 |
| CompletionStatusID | CompletionStatusID value for this delivery attempt (int NULL) | 10.0 |
| Category small | CompletionStatusID / 1000 (int NULL) | 10.0 |
| Type small | CompletionStatusID % 1000 (int NULL) | 10.0 |
| SMTPResponseCode small | The 3 digit smtp response code (int NULL) | 10.0 |
| Time | The timestamp of this log entry (smalldatetime NULL) | 10.0 |
| MailingID | Ties to outmail_.MessageID_ (int NULL) | 10.0 |
| MemberID | Ties to members_.MemberID_ (int NULL) | 10.0 |
| SendTry small | Send attempt count for this recipient (int NULL) | 10.0 |
| InmailType | "bounce" = lyrMemberBounceLog, "complaint" = lyrMemberComplaintLog (varchar(255) NULL) | 10.0 |
| SMTPResponseText | The last line of text received from the remote SMTP server (varchar(255) NULL) | 10.0 |
| ListID | ID of the list used for this mailing (int NULL) | 10.0 |
| Email address of the recipient (varchar(255) NULL) | 10.0 | |
| BodyFrom | The visible From: header (varchar(255) NULL) | 10.0 |
| MailFrom | The envelope From: header (varchar(255) NULL) | 10.0 |
| RcptTo | The intended recipient (varchar(255) NULL) | 10.0 |
| FromDomain | The domain ListManager is sending from (varchar(255) NULL) | 10.0 |
| ToDomain | The domain of the recipient (varchar(255) NULL) | 10.0 |