sfmc // MobileConnectPRODUCTION
Recent MobileConnect Opt-Outs
Review recently logged SMS opt-outs without assuming every row has a SubscriberKey.
sqlsmsoptoutsubscription
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verified2026-10-05
Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.
Consent investigation.
Validating a MobileConnect deployment or unexpected audience drop.
SELECT
LogDate,
MobileNumber,
SubscriberKey,
SubscriptionDefinitionID,
OptOutStatusID,
OptOutMethodID
FROM _SMSSubscriptionLog
WHERE LogDate >= DATEADD(day,-7,GETDATE())
AND OptOutStatusID = 1_SMSSubscriptionLog stores mobile subscription events and can contain records for net-new numbers without a created contact.
Do not require SubscriberKey in the filter; a net-new number can text STOP without a contact being created.
Only the first subscription event for a given status is logged.