I would like to write a query that uses the status of a SMS send. For query require SMS event time of send, details about if SMS failed plus any other useful SMS tracking data information.
For query require the data views names for where SMS tracking data is stored.
As far as I know, there are no SMS activity system data views. The only SMS-related one that I'm aware of is the SubscriberSMS view:
SFMC Data Architects can create system data views that you can use in your account. It requires an engagement, but it can be cost-effective if your work-around solution is crazy.
