USSD short code traffic are not found in the CDR or DB

[croufay]

We have an issue with a project we are currently working on for a customer. They want to get some CDR for the USSD short code on Restcomm. I am unable to get any USSD details out of Restcomm. I am looking directly into the DB but still nothing. Here is an example

mysql> show tables;
+---------------------------------------+
| Tables_in_restcomm |
+---------------------------------------+
| restcomm_accounts |
| restcomm_announcements |
| restcomm_applications |
| restcomm_available_phone_numbers |
| restcomm_call_detail_records |
| restcomm_clients |
| restcomm_conference_detail_records |
| restcomm_extensions_configuration |
| restcomm_gateways |
| restcomm_http_cookies |
| restcomm_incoming_phone_numbers |
| restcomm_instance_id |
| restcomm_media_resource_broker_entity |
| restcomm_media_servers |
| restcomm_notifications |
| restcomm_outgoing_caller_ids |
| restcomm_recordings |
| restcomm_registrations |
| restcomm_sand_boxes |
| restcomm_short_codes |
| restcomm_sms_messages |
| restcomm_transcriptions |
| update_scripts |
+---------------------------------------+
23 rows in set (0.00 sec)

mysql> select phone_number, friendly_name from restcomm_incoming_phone_numbers;
+--------------+----------------------------------------------------------------------+
| phone_number | friendly_name |
+--------------+----------------------------------------------------------------------+
| *111# | Integration Test |
| +1238 | This app calls registered restcomm client Alice |
| +1235 | This app plays the Hello World msg and requires Text-to-speech |
| *700# | Activate account for username |
+--------------+----------------------------------------------------------------------+

Notthing returned for the following:

select * from restcomm_call_detail_records;
Empty set (0.00 sec)

mysql> select * from restcomm_sms_messages;
Empty set (0.00 sec)

mysql> select * from restcomm_short_codes;
Empty set (0.00 sec)

[FerUy]

Furthermore, what they want is a field that tells where the service finished (in which module). Maybe create another issue for this? It's quite a common request...

[otsakir]

@FerUy, this doesn't look like an RVD issue. Shall i remove the VisualDesigner label ? Is this about adding more info to CDR ?

[FerUy]

@otsakir, not sure. What the customer wants (and it's a quite common feature offered out there) is a navigation CDR with a field like this: {1,4,5,8} or {1,2,1,3,1,2} which would mean the user used modules/steps 1-4-5-8 or 1-2-1-3-1-2 (just to put a couple of examples... look at support ticket #34033 for a reference). I agree with you that maybe it's not strictly VisualDesigner stuff but it's related to it.
I guess you have a clearer picture now, right?

[FerUy]

@otsakir @gvagenas @maria-farooq please see if attached proposal is achievable (it's related to Zendesk ticket #34033 and previous experiences with Telcos) and how could we mix it/enhance it in order to making it sort of "Restcomm compliant"
CDR_proposal_FM.xlsx

[croufay]

@FerUy

Please create a new feature request for this.

charles

[FerUy]

OK @croufay 👍

[FerUy]

@croufay as agreed, opened the issue #2030. As told, this one could be seen as a duplicate of the latter, which is broader.