cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
283
Views
3
Helpful
2
Replies

SQL Query, Monthly CDR report

a.pawar
Level 1
Level 1

Hi

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?

Cheers

Ati

2 Replies 2

jbarcena
Level 9
Level 9

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.

//Jorge

how about CCM 5 though?

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: