brycecaruthers
2/15/2017 - 6:01 PM

Calls to bridge extension from specific dnis - this particular query pulls dnis, ani, extension name, call_begin_datetime, and audio for cal

Calls to bridge extension from specific dnis - this particular query pulls dnis, ani, extension name, call_begin_datetime, and audio for calls by dnis and the dnisid of the specific extension they route to. Originated from case 114988 for reference

extension_by_dnis.sql
content_copyfile_download
SELECT p.dnis AS 'Tracking Line', p.ani AS 'Customer', d.bridgeval AS 'Extension', p.call_begin_datetime AS 'Call Date Time', a.audiofile AS 'Audio Link'
FROM xcall_long x
	JOIN xcall_long_platform p ON p.frn_callid = x.callid
	JOIN xcall_long_audio a ON a.frn_callid = x.callid
	JOIN dnis d ON d.dnisid = x.extension_frn_dnisid
WHERE p.dnis = 8448101296
	AND x.extension_frn_dnisid = 3762357
	AND p.call_begin_datetime BETWEEN '2017-02-08' AND '2017-02-15'