Count number of inbound calls 2

[vaniello]

What is the best (and easiest) way to count the total number of incoming calls, both through the autoattendant and direct to extensions with DIDs, coming into my IP Office system? I am running IP Office 3.2.55 with Voicemail Pro.

V/

 

[Drew2400]

The simplest way that I can think of is to use DeltaServer to report the SMDR to file(s) on a drive.

Import the log files (which are comma-delimited CSV files) into Microsoft Access. You can then run a query with Totals turned on. Group by line or extension if you wish and be sure and select only external calls (i.e. direction = I and is_internal = 0 and continuation = 0).

I believe the continuation is for calls that are transferred which creates a second SMDR entry (which you don't want). Err... Or maybe you do?

In any case, there is a wealth of information available in the log files. Keep in mind, the current day SMDR is written to a different file and is cumulative for that day. Until, DeltaServer renames it to ...date.log

Also, DeltaServer is free (located on the Admin disk in CBC folder.

Hope this helps.

 

[vaniello]

Thanks, I was able to get Deltaserver running and logging calls.

Now I have another logging/reporting question.

Is there a way I can obtain reports on trunk utilization (both past and present) for my IP Office?

Thanks.

V/

 

[tlpeter]

for reportsyou need a call accounting system
or you have to dig thrue the smdr logs


______________
Women and cats can do as they please and men and dogs should relax and get used to the idea!

 

[Drew2400]

Truly, you'll need to write something in Access (or sql if you prefer).

I believe there are column descriptions in the SMDR PDF.

You'll be able to see how much time has been allocated to a particular line as it is denoted in the SMDR data. So, you could total by line or by user.

I've done quite a bit of analysis in the past with regards to SMDR (Nortel DMS100 stuff). That was a 1.2 million record database. But, the IPO does a much better job on reporting.

Hope this helps.

 

[TheDoz]

Also, 4.0 software has a System Status program that tells you of trunk incoming and outgoing usage.
It is a cool program in 4.0 IP Office gets better after every release.

"The lack of money is the root of all evil

 

[vaniello]

Does anyone have a recommendation for a call accounting package that will provide reports on overall trunk utilization?

Thanks.

V/

 

[tlpeter]

i have used phonex pro and works well

http://www.mindcti.com/

______________
Women and cats can do as they please and men and dogs should relax and get used to the idea!

 

[Drew2400]

For myself, I usually write my own stuff in Access. Haven't done much in a while. You can certainly get quite alot of data with that.

What types of things are you trying to report?

Drew

 

[vaniello]

Right now all I would like to report is the number of inbound calls, daily, weekly, monthly, etc. and the overall trunk utilization.

V/

 

[bigjerms]

Tapit is a good call accounting app

 

[jamie77]

Oak do good stuff

Jamie Green

IPO ACA:Implement

http://www.alliedcom.co.uk

Fooball is not a matter of life and death-It is far more important!!!!

 

[menosat]

If you upgrade to Office 4.0, Delta Server will not work without licensing like it does in earlier versions.

 

[Drew2400]

Is that true? It works for me. I'll have to do some research on that. Hmmm.

 

[PotNoodleBoy]

Can anyone else confirm that you can't use Delta server in this way with v4.0??

 

[intrigrant]

There is no change in the use of DeltaServer, it is still unlicensed. The only thing is that you need a new DeltaServer to connect to 4.0, it is on the admin cd in the folder CBC.