12-13-2007 08:35 AM - edited 03-13-2019 04:48 PM
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
12-13-2007 09:09 AM
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
12-13-2007 10:49 AM
how about CCM 5 though?
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: