---
schema_version: "1"
id: aed2e47f116fa8564f0577dd287272cc27a3da34f6dba0d51ad7ee0669d26939
title: "Data View: Undeliverable SMS"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_undeliverable_sms.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_undeliverable_sms.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 506045a98356a915edb55b3a6abe8457debdc1bdcb178584b5c682d60fa7fb6b
description: To find failed SMS message deliveries to MobileConnect subscribers, query the _UndeliverableSMS data view.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: Undeliverable SMS

To find failed SMS message deliveries to MobileConnect subscribers, query the \_UndeliverableSMS data view.

Information from this query relates to the owner of a private short code or long code, or a client using a shared short code to which the subscriber has opted in.

Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png)

Note When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the \_EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here.

## Columns

    
| Name | Description | DataType | Data Extension Data Type | Nullable |
| --- | --- | --- | --- | --- |
| MobileNumber | Mobile number for the subscriber | varchar(15) | Phone |   |
| Undeliverable | Indicates that the number is Held and that MobileConnect discontinued sending messages to the subscriber | bit | Boolean |   |
| BounceCount | Number of bounced SMS messages for subscriber | smallint | Number |   |
| FirstBounceDate | The date when the first bounce occurred | datetime | Date |   |
| HoldDate | The date when MobileConnect discontinued sending messages to the subscriber | datetime | Date | X |

#### See Also

- [Bounced Messages and Held Numbers](https://help.salesforce.com/s/articleView?id=mktg.mc_moc_bounced_messages_and_held_numbers.htm&type=5&language=en_US)
- [Review Undelivered Messages](https://help.salesforce.com/s/articleView?id=mktg.mc_moc_retrieving_information_on_undelivered_sms_messages_for_mobileconnect.htm&type=5&language=en_US)