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.
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';
.
.
.