Querying CDR or CEL for Voicemails

configuration
voicemail
freepbx
Tags: #<Tag:0x00007fb47d724d20> #<Tag:0x00007fb47d722408> #<Tag:0x00007fb47d7221d8>

(Curtisg) #1

Hey Guys,

Does anyone have thoughts on the best way how to query CDR, or CEL for voicemails and their eventual endpoint?

It seems like that info gets obscured as it goes through ring groups, queues & etc.

Looked at VM reports module, and apparently that doesn’t include “reports”. This would be to transfer to someone with no access to admin so it wouldn’t be helpful.

Thanks!


#2

Calls that end up in voicemail:-

mysql asreriskcdrdb -e "select uniqueid, linkedid from cdr where lastapp='voicemail' order by calldate desc limit 5;"

+------------------+------------------+
| uniqueid         | linkedid         |
+------------------+------------------+
| 1626226098.85274 | 1626226098.85274 |
| 1626212146.85224 | 1626212146.85224 |
| 1626200984.85125 | 1626200984.85125 |
| 1626125295.85042 | 1626125295.85042 |
| 1626112307.84912 | 1626112307.84912 |
+------------------+------------------+


All segments that led up to it can be isolated by the uniqueid

mysql asteriskcdrdb -e "select * from cdr where uniqueid='1626226098.85274' order by calldate desc limit 5;"
.
.
.
.

mysql asteriskcdrdb -e 'select * from cel where linkedid='1626226098.85274';
.
.
.



Maybe that can get you started


(Curtisg) #3

Thanks! It’s too bad theres nothing in the front end to search this, but this is definitely helpful.

Thanks again!