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 it into reporting. I'm using * 1.6.2
> + mysql - realtime (no gui). Any suggestions / open-source / AGI on where to
> start looking into implementing something like this?
Just use SNMP to get the channel usage. If you don't want to use SNMP, then just
use something like GROUP(), GROUP_COUNT() and func_odbc to write channel usage
to the database. Something like....
[Outgoing]
exten => _NXXNXXXXXX,1,NoOp()
same => n,GoSub(subTotalCallCounter,start,1(outgoing))
[subTotalCallCounter]
exten => start,1,NoOp()
same => n,Set(GROUP(totalcalls)=${ARG1})
same => n,Set(ODBC_TOTAL_CALLS(${ARG1})=${GROUP_COUNT(${ARG1}@totalcalls)})
same => n,Return()
[Incoming]
exten => 4165551212,1,NoOp()
same => n,GoSub(subTotalCallCounter,start,1(incoming))
[LocalSets]
exten => _1XX,1,NoOp()
same => n,GoSub(subTotalCallCounter,start,1(internal))
func_odbc
---------
[TOTAL_CALLS]
dsn=myDatabase
writesql=INSERT INTO totalCalls ('type','callcount') VALUES
('${VAL1}','${ARG1}')
Something like that. Totally untested and only written in this email :)
Leif.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
