The lyrDAOMailStreamTracking is used to hold aggregated sending attempt data for each Mailstream, for a specific completion status within the specified interval. The intervals are approximately 5 minutes long, and are accumulated in memory before being written out to this table. Typically 1 week of data is kept in this table.
| Field Name | Description | Version Added |
|---|---|---|
|
MailStreamID |
The MailStream associated with this data (int, NULL) |
10.1 |
|
CompletionStatusID |
The completion status, from the lyrLookupCompletionStatus table. (int, NULL) |
10.1 |
|
Count |
The number of send attempts resulting with this CompletionStatusID within the interval (int, NULL) |
10.1 |
|
IntervalStart |
Start time of the collection interval (smalldatetime, NOT NULL) |
10.1 |
|
IntervalEnd |
End time of the collection interval (smalldatetime, NOT NULL) |
10.1 |