SMSMTEvent
Contains information on a specific SMS message sent to a subscriber.
View-Specific Information
Select
The driver uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The driver processes other filters client-side within the driver.
For example, the following (but not only) queries are processed server side:
SELECT * FROM SMSMTEvent WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM SMSMTEvent WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM SMSMTEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | System-controlled, read-only text string identifier for object. |
| EventDate | Datetime | Date when a tracking event occurred. |
| Client_ID | Long | The Id of the client. |
| MOCode | String | Specifies the MO code associated with a specific MO or MT tracking event. |
| SMSTriggeredSend_SMSSendId | String | Indicates ID for a specific SMS send. |
| SMSTriggeredSend_SMSTriggeredSendDefinition_ObjectID | String | System-controlled, read-only text string identifier for object. |
| SMSTriggeredSend_SMSTriggeredSendDefinition_CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| Subscriber_ID | Int | Read-only identifier for an object. |
| Subscriber_SubscriberKey | String | Identification of a specific subscriber. |
| Subscriber_PrimarySMSAddress_Address | String | The primary SMS address of the subscribers. |
| Carrier | String | Name of the SMS carrier associated with an SMS address. |