Select
call_req_id, -- Join with ref_num in call_req table (bemerson's post)
time_stamp, -- Convert to datetime
analyst, -- Join with contact_uuid in ca_contact table
description
From act_log -- where activity logs are stored (Naveen's post)
Where type in ('LOG', 'SOLN', 'TR') -- Logged Comments, Solutions, Transfers
and time_stamp > '1404172800' -- since June 1st 2014 00:00:00 GMT (act_log likely has millions of records)
-- Hope this helps!