CDR reports for TEHO/TollBypass

Unanswered Question
May 13th, 2008


can you tell me which field names or atributes to query for in CDR to get reports on toll bypass usage? i'm also try to get reports for WAN call volume to quantify bandwidth & qos. any insight? thanks....

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
ivillegas Mon, 05/19/2008 - 10:52

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 Call Detail Record 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.


This Discussion