Asterisk log reports using MS SQL2005

Asterisk call logs into a MS SQL2005 db.

The solution should parse the log files into the db (manual import), and use SQL report services to view the reports. I need help with what exacly the reports should present, below can be discussed:

Total calls

select extension (or all) between date/time show:

# Total nr calls in / out

# Avarage call time

ACD between dates:

select ACD and beween date/time show:

# Comleted calls

# avarage call time (and select between wait time and talk time)


# hang up before answered

ACD Agent

Select ACD and agent and between dates

# Logged in time

# Comleted calls

(The reason for not using already made report engines is to prepare for future analys services with other sql2005 db:s)

Deliver with basic installation instruction and 2week mail support.

Selected provider will have continue work for this applic. Asap delivery.

there is a opensource project that have exactly what i want. I would like to have it running in IIS and help with setting up Asterisk to log to the MS db directly. The two reports that i need asap is:

You are free to use what ever report tool you want as long as it is run in Asp.

I need full IPR rights to the application.

No provider is selected yet,

Habilidades: .NET, Área de trabalho do Windows

Ver mais: talk agent, log into, delivery agent, asterisk sql2005, avarage call time, asterisk log calls sql, work logs, what is ms sql, using asterisk, log time, talk show, Sql reports, ms s, log files, instruction, instruction manual, hang, asterisk, asterisk + c#net, net call asterisk, can log reason, windows extension, help using, report using, parse log

Acerca do Empregador:
( 3 comentários ) Warsaw, Poland

ID do Projeto: #128685