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: 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\4\40\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.