According to Cisco documentation 'For the consultation call, the origCause_value and destCause_value fields get set to split = 393216, which indicates that the call was split. I need to capture all legs of a transferred call. I have exported all my cdr records into a sql database for reporting. The "%" is a match of zero or more characters while the underscore "_" means any single character. The where clause above captures any string contain 5 followed by 3 characters (assumed to be numeric given the context of the question).
OriginalCalledPartyNumber, finalCalledPartyNumber Select datetimeOrigination,callingPartyNumber, See this link as a good reference point: I always use LIKE for no other reason other than that is what I used with other DBMS query interpreters. LIKE is the ANSI standard whereas MATCH is the Informix extension. There are wildcards you can use when the where clause uses LIKE or MATCH. You would need something along those lines as you can't dump the results to a file on the CUCM node.Ģ. In practice, I actually use a tool I developed to run the queries remotely. Yes, I am using the CLI for examples to give people an interface they can use straight away to get familiar with the interface. This information is accessible by running the following query: ( You can run the query from the CLI using run sql )ġ. The first requirement was to identify calls to international destinations. This table stores all of the elements we need to accomplish the task at hand. The table we are most interested in is the tbl_billing_data table. Starting in CUCM version 8.0, you actually specify the data source prior to the select clause. In versions of CUCM prior to 8.0, you would identify the CAR database in the from clause. Note that we are clearly identifying the CAR database when defining the query. *if access CAR data for version 8.x and newer*/Īdmin:run sql car select from where *if accessing CAR data from CUCM 5.x to 7.x*/Īdmin:run sql select from car: where However, to access the CAR database you would actually need to reference the database by name. The above command is accurate when querying the CUCM (or CCM) database.
Actually, if we want to get all nostalgic about it, CAR is the "artist formerly known as" ART. CAR is an application that Cisco has included with CUCM since before the name change from "CallManager".
For this week's post I am going to explore the Cisco CDR Analysis and Reporting (CAR) database.