[finding calls for extensions] #freepbx

ext_calls.sql

SET NAMES 'UTF8';
SET CHARACTER SET 'UTF8';

SET @EXT = 7443;
SET @EXTV = concat('vmu', @EXT);
SET @CHANNEL = concat('%/', @EXT, '-%');

SELECT * FROM asteriskcdrdb.cdr
where (
	dstchannel LIKE @CHANNEL 
	OR channel LIKE @CHANNEL 

	OR src = @EXT 
	OR dst = @EXT 

	OR src = @EXTV 
	OR dst = @EXTV 

	OR cnum = @EXT 
	OR cnum = @EXTV
)
order by calldate desc