How do you use the Cisco CallManager CDR database to determine the list of all the toll calls that have been placed?

[TCC_2]

Resolution

To determine the list of all the toll calls, run an SQL query using the following procedure:

1. Select Start > Programs > MS SQL Server > Query Analyzer.
2. Enter the query given below:

   use cdr select callingPartyNumber from CallDetailRecord 
   where originalCalledPartyNumber like '47%'
   or finalCalledPartyNumber like '47%'

3. Hit F5.

   This displays all the phone numbers/extensions that called 47%.

An alternate procedure is given below:

1. Select Start > Programs > MS SQL Server > Enterprise Manager > CallManagerName > Databases > CDR > Tables.
2. Right-click on CallDetailRecord.
3. Click Open Table.
4. Select Return all Rows.
5. Click the  SQL icon.
6. Enter the following:

   select callingPartyNumber, dateTimeOrigination, 
   originalCalledPartyNumber from CallDetailRecord 
   where originalCalledPartyNumber like '4155016000' or
    finalCalledPartyNumber like '4155016000' 

7. Hit the ! to run query.

   Note: % is used as a wildcard. Numbers 47 and 4155016000 are used as an example in this Cisco TAC Collection Case. It can be any other number you would like to query.

For additional information, please refer to Using SQL Queries to Search the Call Detail Record (CDR) with Cisco CallManager.

Problem Type

Ask a how to ... question

Call control software  (CallManager, CallManager Express, ICS7750, SRST, SS7 call agents)

Call Control

CallManager

CallManager Features

Database

How to ...

How to ... CallManager call detail records

Call Topology and Direction

To long distance national number

To mobile network

To international destination

Call Detail Records (CDR)

CDR database

CallDetailRecord table

Operating System Components

SQL