CDR Report - Show Extension Calls but not include VM

FreePBX Applications / Modules
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.

2

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.

3

Thanks. That was a big help.

1 Like
4

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