Use table Incoming SMS (InSMS).  You have limited number of fields to query.  But you can get both sending and receiving phone numbers, and the message that was sent.  Unfortunately you have to substring out the phone numbers.  

Thanks David. I appreciate the answer. I was just trying to post to get an access token. This feature is very limited. Pretty much useless for most api's.

How do you do a POST from an External API Activity.  It seems to only work for GET.

Did you find an answer Debanjana?

Query the Delivery Log

I run a monthly query over the delivery log by profile.  Then I count how many profiles received less then 5 emails a month, 5-10, 11-15, 16-20, 21-30, 31+.  Here is what it looks like.

I created a workflow that consolidate all subscriptions on to 1 profile.  It doesn't move history or other profile attributes.  After a period a time the merged profile will have no history, and I will them run a delete workflow. The workflow is pretty complicated and it use many file up and downloa...

Tried wildcard like in comments below with same result, it doesn't work. Below is not a accepted solution.

Create a query say over the profile table, then use Additional Data to count the number of rows.  Then use Segmentation to analyze the count.

Is there a way to add a search box for Mobile Phone Number under Profiles in ACS?  The question is about the User Interface and not the API.  Mobile Phone number is on the Profile (Recipient) table and not the profile extension table. Thanks,  John