Open Source Training Seminar


Not Logged in - No Account?

Logging in allows you to post to forums, track new posts, subscribe to threads, pm (private message) other members, and receive periodic news letters. Once logged in this message disappears. No account? Create one by registering here. Lost your password, request a new password. We respect your privacy and collect minimal information when you register and we do not resell that information or use it in any objectionable way. You can review our privacy policy for details.


Newbie question on FreePBX reports

stevieboy_uk's picture
Posted September 18th, 2008 by stevieboy_uk (tadpole)

Could someone please help. I am relatively new to FreePBX and am trying to find out how to get simple reports using the reporting tool in the administration GUI.

All I am trying to do is find out how many unique incoming calls we are getting on a daily or monthly basis but am finding it very difficult to extract this simple information.

Any assistance would be gratefully received.


__________________


‹ Help with HUD Missing other destinations within inbound routes ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Click on the reports tab in

jmullinix's picture
On September 18th, 2008 jmullinix (Leap Frog) said:

Click on the reports tab in FreePBX and scroll down. I believe what you are looking for is right there.


__________________

John Mullinix, Cohutta.Com, Inc.
1-706-632-3343 -- sip://17066323343@qth.cohutta.org
Looking for Dundi peers in Baltimore, MD and Lake Wales, FL USA


I tried that

stevieboy_uk's picture
On September 18th, 2008 stevieboy_uk (tadpole) said:

I have tried that but the problem lies in what info is required in the destination, source and channel fields???

All I really want to do is identify incoming calls over a certain period (i.e. a single day).

The problem I have had is when looking at the table there are multiple entries for a single inbound call which is difficult to use.

Thanks anyway.


Use standard SQL wildcard characters in your search

sasargen's picture
On September 18th, 2008 sasargen (Developer) said:

stevieboy_uk,

You should be able to use SQL wildcard characters % and _ to match the DESTINATION, SOURCE, and CHANNEL in your call records. The following method may work for you, but you may need to adjust it for UK dialing patterns.

  1. Go to the Call Logs tab under Reports.
  2. Select Selection of the month, make sure From: and To: both indicate the same month, and check the checkboxes next to From: and To: (if you are reporting on the current month, uncheck the checkbox next to To:) .
  3. Make sure DESTINATION, CHANNEL, and DURATION are blank.
  4. For SOURCE enter _______ (seven underscore characters) and choose the Begins with radio button.
  5. Click Search button.

Step 3 above forces the report to only count calls with a Source that is seven or more characters long. Since the external callers have telephone numbers seven or more numbers long, all calls from external callers are included, but calls from the shorter internal extensions are not counted. The Number of calls : shown directly above the - Call Logs - table indicates the total number of calls for the month you selected above. Below the - Call Logs - table is a TOTAL table. It lists call statistics by day. The CALLS column indicates the total number of calls for that day.

You'll need to sanity check the results. Depending on how your trunks and routes are setup, some outgoing calls may appear to be sourced from one of your outgoing CIDs. If that happens, you can use other conditions to try to eliminate those calls from the results. If you have certain trunks that are only used for incoming calls, you can search for those in the CHANNEL field like using wildcards.

I hope that gives you something to work with.

Thanks, Seth


Thanks

stevieboy_uk's picture
On September 18th, 2008 stevieboy_uk (tadpole) said:

Thanks for the advice. I will give it a try.

Kind regards

Steve