CDR Report - Show Extension Calls but not include VM

(Sean Mc Cauley) #1

I’m trying to figure out a CDR report that would show all answered calls to a single extension but not include the calls that were answered by voicemail.


The GUI doesn’t have a filter on ‘lastapp’ but

mysql asteriskcdrdb -e " SELECT * FROM cdr WHERE Lastapp != 'VoiceMail' AND dst='${YOUREXTENTION}' "

Might be a good start.

(Sean Mc Cauley) #3

Thanks. That was a big help.