Re: [asterisk-users] concurrent call tracking

2011-05-12 Thread Arunas Junevicius
Hi, this is my first post to mailing list, so sorry in case i'm doing something wrong. when i want to count concurent calls from particular user, i dont use any cron jobs or counters in dialplan, run query on cdr, something like: SEELCT dst, calldate, IF(action = 'substract', @count := @count -

Re: [asterisk-users] concurrent call tracking

2011-05-12 Thread Leif Madsen
On 11-05-11 06:36 PM, Skyler wrote: Thanks Dovid, if you don't mind sharing the code and the dial plan side I'd like to take a look at it for sure. The dial plan example Leif replied with is pretty much what I was thinking, just didn't have a clue how to go about it. ;) You could also look

Re: [asterisk-users] concurrent call tracking

2011-05-12 Thread Skyler
To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] concurrent call tracking On 11-05-11 06:36 PM, Skyler wrote: Thanks Dovid, if you don't mind sharing the code and the dial plan side I'd like to take a look at it for sure. The dial plan example Leif replied with is pretty much what

Re: [asterisk-users] concurrent call tracking

2011-05-11 Thread Leif Madsen
On 11-05-11 12:57 PM, Skyler wrote: 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

Re: [asterisk-users] concurrent call tracking

2011-05-11 Thread Stelios Koroneos
You can use the manager api (interface) and poll that info and then store it in a MYSQL table etc. You can do this outside asterisk,even from a different machine using your preferred dev language as there are manager libraries/bindings for most major dev languages 'Actual' is the key word

Re: [asterisk-users] concurrent call tracking

2011-05-11 Thread Dovid Bender
What I do is when ever a call comes in I update a table in MySQL to active = (active +1). On hang up I do active = (active -1). I have a cron that checks once a minute to see how many active and stores it along with epoch in db. I then have a graph that shows channel usage. If you want the

Re: [asterisk-users] concurrent call tracking

2011-05-11 Thread Steve Edwards
On Thu, 12 May 2011, Dovid Bender wrote: What I do is when ever a call comes in I update a table in MySQL to active = (active +1). On hang up I do active = (active -1). I have a cron that checks once a minute to see how many active and stores it along with epoch in db. I then have a graph

Re: [asterisk-users] concurrent call tracking

2011-05-11 Thread Skyler
Discussion Subject: Re: [asterisk-users] concurrent call tracking What I do is when ever a call comes in I update a table in MySQL to active = (active +1). On hang up I do active = (active -1). I have a cron that checks once a minute to see how many active and stores it along with epoch in db