search for: totalcalls

...t and so far there is no joy The thing is I can do this update from the command line: Maybe some new eyes might find the answer? exten => update,1,MYSQL(Connect connid localhost root password dax) exten => update,n,MYSQL(QUERY resultid ${connid} UPDATE\ caller\ SET\ lastcall=${LASTCALL}\,totalcalls=totalcalls+1\,currentcalls=currentcalls+1\ WHERE\ dnis=\'${IVR-Exten}\'\ AND\ ani=\'${CALLERID(number)}\') exten => update,n,MYSQL(Clear ${resultid}) exten => update,n,MYSQL(Disconnect ${connid}) Asterisk logs says: Apr 19 15:50:05 VERBOSE[19740] logger.c: -- Executing MYSQ...

...e setup per queue. My next project is to add the ability to announce the callers estimated wait time. I want some feedback to see whats the best method to calculate that? What do you want just minutes? or minutes and seconds? Or the option to use one or the other? I'm thinking (totaltime / totalcalls) - (now - qe->start) = current estimated wait time. Which would update after each call is hungup. http://bugs.digium.com/bug_view_page.php?bug_id=0000214 Please let me know what you would like to see!?!?! Thanks, bkw

Hi all, I would like to track/store concurrent call usage per user by day/week/month and get server totals by day/week/month. Google comes up with mostly info regarding concurrent call limits, though my goal is to calculate actual concurrent channel usage and add it into reporting. I'm using * 1.6.2 + mysql - realtime (no gui). Any suggestions / open-source / AGI on where to start looking