Call Reporting

[cdamiano]

We have a Definity One switch running software version G3V7c. Looking to find out if I can run a report to show number of calls and amount of time per call for incoming/outgoing calls to/from a particular extension. Are there any additional features that we would need installed to do this? Played around with the list measurements reports but didn't see anything that would provide this information.

 

[mikeydidit]

You can use the "list measurements” hourly/summary commands on your trunk groups but for detail call recording you will need some sort of a call accounting system. Microcall offers a very nice product at a reasonable price.

Mike Jones
LSUHSC

 

[FortKnox]

I am still running my Web based CDR reporter over tcp/ip back to SQL server and up to my custom web pages. Its working quite nicely. I've shown it to some Avaya Business Partners, they are very impressed. It does what the super expensive CDR software companies do. I had a post on here once a long time ago about how to set it up and use it, but my old account all my threads got deleted from tek-tips.

My question is this. In my SQL server I notice that some of my hunt group agents have higher-than-possible call durations. Does the switch tack on to that user the number of seconds that the agent held on hold PLUS the time that they talked to them?

Because what I am seeing is like:
092804 1232 01235 8166658900 125 3150
092804 1234 01043 8704774123 125 3150

(In order above this is date,time,duration in seconds,calling number,trunk,and dialed numer)

So clearly it is not possible that extension 3150 spoke on the phone for 1235+1043 seconds between 12:32pm and 12:34pm.

 

[Toni269]

There was another thread about this same problem: thread690-755336

 

[croz311]

how are you getting the call detail data into your sql database? does ECH have to be turned on, or is there another way to get to it?

 

[FortKnox]

First of all, I started out by following thread690-684030

Then, I with some help, I wrote a program that captures all the raw data and pipe it into SQL Server. If you are serious about it, give me an email address.

Then, I have written a web page that allows the user to query the database by either click or using drop downs. Its pretty sweet.

 

[phonedud]

I would like tosee how your program works and my email address is ralph_waldren at via-christi.org

 

[gunslngr]

CaNiBuS would you mind sending me a copy of the program. I plan on trying to write my own and it would be nice to see how somebody else did it. If not thats okay.

Thanks
Will
wschnei@charter.net

 

[comdata]

CaNiBuS, I would appreciate seeing a copy of your program as well. My email address is ics at mc.net.

Thank you

Alex

 

[tkinney]

Me too, please and thank you!
Glad your back!
Tina
kinneyt@treeoflife.com

 

[ductTape]

CaNiBuS,

Sounds cool, can you send me a copy to look at. I was planning on doing something like this myself so if I can see how you did it, it would be a great help. My plans are to fill a mySQL database and then have a few php pages to display/filter the data.

Please send to asbestoast at comcast.net

 

[Florchita]

Maybe a copy to me?... leangatti at gmail.com

Many thanks...