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

NOTE: This article applies to Chronicall/ACR version 4.0+ installations only

When we need to find the recording associated with a call, we can look in the BlueDB database for the oldId 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 BlueDB database using a simple query.

Steps

1. Take the Call-ID shown on the left-hand side of Cradle to Grave
   
   
   
   
   • This example is for Call-ID 17671
2. In a Chrome-based browser open the diagnostic page for the BlueDB
   • Example

     • http://{ACR IP Address here}:9080/diag?page=blueDbQuery

3. NOTE: Please be very careful what you do on the Diagnostics page as you can negatively impact your Chronicall/ACR installation and functionality should you perform the wrong action
4. Under the BlueDB Query section
   1. Set Collection to 'calls'
   2. Start and End to the time frame of the call
   3. Enter the Call number in the Search Terms field
   4. Hit the "Show (max 10)" button
      
      
      
5. You can use ctrl + f to search for the term: oldId
   • NOTE: There may be multiple results for oldId and you will need to note the oldId for the Talking event you need
   • For example:
     • If you wanted the oldId for an outbound Talking event on our example call from above, you would choose the oldId below the Talking event for shortCallID 175671:
       
       
       
       
6. With this oldId, you can find where the recording file is located in the storage pool
   1. For the example above, it would be in

      • C:\Program Files\Avaya Call Reporting\recording library\0\0\13\160.spx

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