Aspicore SMS Gateway Demo

Send an SMS message beginning with keyword "TEST" followed by an arbitrary text (e.g. "TEST 1") to number +358503733943. Then refresh this page and you should see the results below. (Normal SMS price depending on your GSM operator.) For more information: www.aspicore.com Top 10: Counts of the 10 most commonly sent SMS messages starting with "TEST" in the Aspicore SMS Gateway database.   Count for 'TEST': 1 (100%)   Most recent 10: The 10 most recent received SMS messages starting with "TEST" in the Aspicore SMS Gateway database: Time From phone Message 20.12.2009 1:48:03     '+919841948***'     'TEST '

The last three digits of the phone number are masked in the demo to protect the privacy of the test users. In a real application the complete phone number is available in the database. This is a simple application example of the Aspicore SMS Gateway open SQL interface. In a real application the statistical analysis should be made more tolerant to different formats different GSM phone models use for sending SMS messages. These results were generated by the following SQL clauses:

SELECT COUNT(*) AS CNT FROM RECEIVE_HISTORY WHERE MESSAGE LIKE 'TEST%' SELECT TOP 10 COUNT(*) AS CNT, UPPER(REPLACE(REPLACE(RTRIM(MESSAGE),CHAR(10),''),CHAR(13),'')) AS UPMSG FROM RECEIVE_HISTORY WHERE MESSAGE LIKE 'TEST%' GROUP BY UPPER(REPLACE(REPLACE(RTRIM(MESSAGE),CHAR(10),''),CHAR(13),'')) ORDER BY CNT DESC, UPMSG SELECT TOP 10 * FROM RECEIVE_HISTORY WHERE MESSAGE LIKE 'TEST%' ORDER BY TIME_RECEIVED DESC

Aspicore SMS Gateway flyer (Adobe PDF, 489kB, English)