How To Find The Recording ID from the Database via SQL query

When we need to find the recording associated with a call, we can look in the PostgreSQL database for the Recording ID and then use that to locate the recording in the recording library storage pool

Answer

In order to find the recording associated with a call, we can query the Postgres database using a simple SQL query.

Steps

1. Grab the Call ID from Cradle to Grave. For this example, we use 1908628
   
   
   
   
2. Access the Chronicall server's diag tools
   1. By default, this will take you to the SQL Editor
   2. The diag tool can usually be accessed by suffixing the URL with /diag after the Chronicall URL
      • E.g. http://127.0.0.1:9080/diag
3. Run the below SQL query:

   • select * from c_recording where global_call_id = <call_id>;

     • Where the call_id is the ID you grabbed from Cradle to Grave
4. Click Execute Query
5. The Recording ID(s) for that call will appear in the first column in the Result table
   • NOTE: If this fails, see the Alternate Methods below
     
     
     
     
   • NOTE: For calls with multiple recordings, the resulting table will show the recording_id(s) in the order in which the recordings appear for the call in Cradle to Grave
6. The recording ID naming convention will give you an idea of where the file is located in the storage pool
   • In this example, the recording_id is 440855
     • The recording is located in

       • C:\Program Files(x86)\Xima Software\Chronicall\recording library\0\0\440\855.spx

7. As you can see, the recording ID naming convention gives the folder structure where we can find the recording as well as the name of the recording file.

Alternate Method #1

1. Sometimes, especially in the case of deleted or unassociated recordings, the recording_id won't be tied to the global_call_id
2. In this scenario, you can find the recording_id via the event_id(s) which are tied to the call_id using the below query:

   • SELECT recording_id FROM c_recording WHERE event_id in (SELECT event_id FROM c_event WHERE call_id in (YourCallID(s)Here));

   • See the example below:
     
     
     
     
3. Now all you have to do is simply run the following query to see the recording_id details:

   • SELECT * from c_recording where recording_id = xxxxx

Alternate Method # 2

1. In some situations, the global_call_id will not pull up the call. When this happens you can instead use call_id

   • select * from c_event where call_id = '<insert call_id here>'
     

     
     
     
2. You will see multiple lines that populate but you will be looking for a line(s) with the event_type of 4, this is a Talking event
   • NOTE: Bottom red outline in the example above
3. Use the event_id of the event_type 4 to find the recording_id

   • Select * from c_recording where event_id = <insert event_id here>