When we need to find the recording associated with a call, we can look in the postgres database for the recording id and then use that to locate the recording in the recording library storage pool
In order to find the recording associated with a call, we can query the postgres database using a simple SQL query.
1. Grab the Call ID from Cradle to Grave. For this example, we use 1908628:
2. Access the Chronicall server's diag tools. By default, this will take you to the SQL Editor.
The diag tool can usually be accessed by suffixing the URL with /diag after the Chronicall URL
- (for eg, http://10.0.0.5:9080/diag).
3. Run the below SQL query:
select * from c_recording where global_call_id = <call_id>;where call_id is the ID you grabbed from Cradle To Grave.
4. Hit Execute Query. The Recording ID(s) for that call will appear in the first column in the Result table. Note: If this fails, see Alternate Method below.
Note: For calls with multiple recordings, the resulting table will show the recording_ids in the order in which the recordings appear for the call in Cradle to Grave.
5. 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
- 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.
Sometimes, especially in the case of deleted or unassociated recordings, the recording_id won't be tied to the global_call_id. 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 example below:
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