CDR Report - Show Extension Calls but not include VM

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.

Thanks. That was a big help.

1 Like

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.