Vicidial - Find recording file path based on the uniqueid from vicidial DB

 query to find recording file path in vicidial using unique id 

SELECT 

    rl.location AS recording_path,

    rl.filename AS recording_file

FROM 

    vicidial_closer_log vcl

JOIN 

    recording_log rl ON vcl.closecallid = rl.recording_id

WHERE 

    vcl.uniqueid = '1736587824.145986'; -- Replace with your specific uniqueid