CDR Reports

Unanswered Question
Mar 18th, 2009
User Badges:

Does anybody know if there is any way to run CDR reports to get a count of the number of times a route pattern has been used? I found the utilization report but that does not provide enough details, I need to know exactly how many times a particular route pattern was called. As a side note on this, we use over 200 different route patterns but they all use the same route groups/route lists. I can get reports for the overall utilization but I can't get exact numbers. I have been looking into just doing sql selects from the database but I can't seem to find a table that lists the route patterns or a count. Any help is appreciated.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Hythim Ali El Hadad Wed, 03/18/2009 - 13:16
User Badges:
  • Silver, 250 points or more


Please check this link

Then you will generate a report with the needed call type which will match the needed route pattern

It will help you in what you need,but I think it is limited to only 9 rows if i was right

So you won't be able to check all these great number of route patterns

Wish this be helpful

Best Regards

mpozorski Thu, 03/19/2009 - 07:30
User Badges:

Thank you for the great link but after reading it through I don't think I can set up the dial plan in CAR. It looks to be limited to a total of 13 digits but our route patterns that we are trying to track are 7 digits, so that plus the phone numbers I would need to be able to set the digits to 18. In that link i did find some information regarding exporting the records, so I'm going to try to export the records, and then run some queries against them to see if I can figure out how many times over a week the route pattern is being used. I should be able to use that data and calculate the total number of times it was used. Thanks again for the link, it looks to have pointed me in the direction I need to head.


This Discussion