Filter Live OB (comment out unneeded AND clause) by date and dnis (phone code is c.frn_phonecodeid = )
SELECT h.frn_callid AS 'Call ID', o.short_reference AS 'Live OB Option', p.call_begin_datetime AS 'Call Time', p.ani AS 'Customer', p.dnis AS 'Tracking Line'
FROM xcall_long_hcat h
JOIN xcall_long_platform p ON p.frn_callid = h.frn_callid
JOIN xcall_long C ON C.callid = h.frn_callid
JOIN hcat_option o ON o.hcat_optionid = h.frn_hcat_optionid
WHERE p.dnis = '1111111111'
--AND h.frn_hcat_optionid IN (7,8) /*Not live convo*/
AND h.frn_hcat_optionid IN (6,38823,38824,38825) /*live convo*/
AND p.call_begin_datetime >= '2017-02-01'
ORDER BY p.call_begin_datetime desc