I have a CM 4.1(2) cluster and am running CDR Analysis and Reporting tools. I have reviewed all the standard reports that come with CDR, but would like to write a custom report that shows the number of minutes used by call type (ie. local, long distance, internal, etc.). I've viewed the data stored in SQL, but am unable to find the field for call type. I need to identify each record in the database by call type to accurately report what I need. When you run a report in CDR does it generate the call type on the fly ? Is there a field in the database that coorelates directly to the various call types ?
The Call Type is a field in the reporting configuration and database, and not part of the CDR SQL database.
In the CDR reporting web pages, under system -> System Parameters -> Dial plan configuration is where you set what numbers get set to what call type.
When the nightly CDR load occurs to load CDR data into reports, this is when the data gets put into report (ART) database. The call type is classified at the loading time and can't be changed once it's in the ART by the web. (It's not dynamic, gets set when data is loaded into the database based on report configuration).
In the ART database, it's the tbl_billing_data table then the call_classification field.
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...
This document describe how DST changes and how time changes are
implemented in DST. Daylight Saving Time (DST) is the practice of
setting the clocks forward 1 hour from standard time during the summer
months, and back again in the fall, in order to make b...