Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL Query, Monthly CDR report

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

Re: SQL Query, Monthly CDR report

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

Bronze

Re: SQL Query, Monthly CDR report

how about CCM 5 though?

124
Views
3
Helpful
2
Replies