Hi All,
I’m trying to use FreePBX to record all inbound calls and attach them in a mail at the end with some call details.
It has a simple configuration. I have 5 Misc Destinations (ext mobile number) that are called depending from the caller choise. Everything works fine, but I’m not able to find the Destination (Misc Destination) and the Disposition (ANSWERED, BUSY and so on) variables even if I can see them in Call Detail Record (see below screenshot)
The other variable used are the following (they work properly):
^{YEAR}, ^{MONTH}, ^{DAY}, ^{TIMESTR}, ^{FROMEXTEN}, ^{CALLFILENAME}.^{MIXMON_FORMAT}, ^{ARG3}
Hi Dicko,
I tried your suggestion using the uniqueid to retrieve data from db. I can see the number called under “dst” column but sadly if I try to use it as a parameter the script is unable to get data (empty variable).
I double checked both lower and uppercase but with no luck. Below the screenshot (divided in two pieces) of record got from db (dst is the number starting with 335):
Please post the script you wrote, but basically you need ao add the ^{UNIQUEID} as parameter ‘n’ and if using bash, inside the script use something like :-
DST=$(mysql asteriskcdrdb -e "SELECT dst FROM cdr WHERE uniqueid = '$n' " ORDER BY calldate desc LIMIT 1)
echo $DST
Hello Dicko,
finally I was able to get destination record (I had to add -NB flags before -e to remove heading and ascii art).
Thank you for your support, I really appreciate it!
