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