Absolutely killer for us is CDR searching. May easily have missed it, as I haven't spent a lot of time, but I didn't see an analog for the FPBX CDR reporting.
Without CDR reports with recording playback, similar to FBPX, XIVO is pretty much useless for our installs. Of course there are other reporting solutions, but evaluating/etc is just another hurdle I don't have time for when FPBX is good enough.
More than capable of querying directly(or developing a web-app), but have no desire of the development/maintenance time/$$$/headache involved. We need to be able to setup CDR end-user(s) for search and playback and be done, not get a ticket whenever they need to pull a call. CEL drilldown is nice, but more for forensic purposes than end user use.To retrieve SQLite3 call log data, here are a few examples to get you started:
ALL: sqlite3 /var/log/asterisk/master.db "select * from cdr"
DATE: sqlite3 /var/log/asterisk/master.db "select * from cdr where calldate >= '2016-05-22'"
NPA: sqlite3 /var/log/asterisk/master.db "SELECT * from cdr WHERE clid LIKE '%<843%'"
DEST: sqlite3 /var/log/asterisk/master.db "SELECT * from cdr WHERE dstchannel LIKE '%411%'"
FLDS: sqlite3 /var/log/asterisk/master.db "PRAGMA table_info(cdr)"
To retrieve the CDR log in CSV format suitable for spreadsheets, download:
/var/log/asterisk/cdr-csv/Master.csv
Yes, but only CDR access if not the local admin user.So I think what you're seeking is a CDR Query GUI similar to what FreePBX provides?? Do you actually let users access the FreePBX GUI to do this? Just curious.
You can already do that using an IVR instead of the sound file. Just have the IVR play the message and then the default timeout should point to the voice mail. I'm basing this comment mostly on knowledge of Asterisk config files but I believe the Xivo IVR will let you do it.When a sound file is selected as the destination from a schedule I would like the additional option to forward to a users voice mail afterwards.
How about a way to implement CALL BACK feature with Xivo?
;# // BEGIN CallTrace
exten => *69,1,Set(lastcaller=${DB(CALLTRACE/${XIVO_USERID})})
exten => *69,2,GotoIf($[ $[ "${lastcaller}" = "" ] | $[ "${lastcaller}" = "unknown" ] ]?noinfo)
exten => *69,3,Background(calling)
exten => *69,4,SayDigits("${lastcaller}")
exten => *69,5,Dial(Local/${lastcaller}@default)
exten => *69,6,Hangup
exten => *69,7(noinfo),Playback(unidentified-no-callback)
exten => *69,8,Hangup
;# // END CallTrace
Link up your team and customers Phone System Live Chat Video Conferencing
Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.
Check your inbox!
We’ve sent you an email. Click on the button in the email body to verify your email address – (if you can not find it, check your spam folder).
Upon verification you will be directed to the 3CX setup wizard.