SQL Query, Monthly CDR report

Unanswered Question
Dec 13th, 2007
User Badges:


I am looking for SQL query so that I can generate monthly report for perticular extensions. I need to see the number of calls handled per month. Can anybody help with the query?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)
jbarcena Thu, 12/13/2007 - 09:09
User Badges:
  • Red, 2250 points or more

Please go to Start --> Programs --> Microsoft SQL Server --> Enterprise Manager,

expand the CDR Database, click on Tables, on the right side you should be able to see all

the tables, right click on the CallDetailRecord table and select open table --> Query.

On the window you should see a lot of options, select the box for

OriginalCalledPartyNumber. Under Criteria put the extension that was called and then on the Tool bar click the ! button. You should see all the records about that extension. You can also add the box for calling party.

Hope this helps, if it does, please rate the post.


a.gooding Thu, 12/13/2007 - 10:49
User Badges:
  • Bronze, 100 points or more

how about CCM 5 though?


This Discussion