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.