Table Of Contents
Administrative Tools Overview
Bulk Administration Tool (BAT)
Administrative Reporting Tool (ART)
Cisco CallManager Serviceability
Remote Network Management
Call Detail Records
Enabling CDR Collection
CDR-Related Service Parameters
Removing CDR Records
CDR Database Access
Where to Find More Information
Administrative Tools Overview
This section provides an overview of the following tools for Cisco CallManager administrators:
•Bulk Administration Tool (BAT)
•Administrative Reporting Tool (ART)
•Cisco CallManager Serviceability
•Call Detail Records
•Where to Find More Information
Bulk Administration Tool (BAT)
The Bulk Administration Tool (BAT), a plug-in application to Cisco CallManager, lets you add, update, or delete a large number of phones, users, Cisco VG200 gateways and ports, and Cisco Catalyst 6000 24 Port FXS analog interface modules to the Cisco CallManager database. Where this was previously a manual operation, BAT helps you automate the process and achieve much faster add, update, and delete operations.
You can access BAT from Cisco CallManager Administration using the Application menu.
For more information, refer to the Bulk Administration Tool Guide for Cisco CallManager.
Administrative Reporting Tool (ART)
The Administrative Reporting Tool (ART) for Cisco CallManager, a web-based reporting application, generates the following reports that provide information regarding voice quality and generates reports on the gateway performance.
•Quality of service
•Traffic details
•User call details
•Billing details
•Gateway details
•Call Detail Records
The Cisco CallManager records information regarding each call in call detail records (CDRs) and call management records (CMRs). CDRs and CMRs serve as the basic information source for ART and are stored in the ART database.
Users can only access ART through a secured login. The user ID and password for ART access are the same as the user profile set for Cisco CallManager.
To view the reports, you must use Adobe Acrobat Reader, which you can download and install from the ART main screen.
For more information, refer to the Administrative Reporting Tool Guide for Cisco CallManager.
Cisco CallManager Serviceability
Administrators can use the Cisco CallManager Serviceability web-based tool to troubleshoot problems with the Cisco CallManager system. Cisco CallManager Serviceability provides the following services:
•Alarms—Saves Cisco CallManager services alarms and events for troubleshooting and provides alarm message definitions.
•Trace—Saves Cisco CallManager services trace information to various log files for troubleshooting. Administrators can configure, collect, and analyze trace information.
•Admin Serviceability Tool—Monitors real-time behavior of the components in a Cisco CallManager cluster.
•Control Center—Views status of Cisco CallManager services. Administrators use Control Center to start and stop services.
To access Serviceability from the Cisco CallManager Administration window, choose Applications > Cisco CallManager Serviceability from the menu bar.
For more information, refer to the Cisco CallManager Serviceability Administration Guide.
Remote Network Management
Network management tools, if properly deployed, can provide the network administrator with a complete view into any enterprise network. With the advent of converged networks, it is imperative to have network management systems enable the following capabilities:
•Network discovery and topology maps
•Inventory control and configuration management of networked nodes
•Report generation, system logging, and analysis of the respective data
Cisco CallManager remote serviceability tools and CiscoWorks2000 provide the above capabilities and enable visibility into the health and availability of the Cisco AVVID network. Considerable management features have been added, starting with Cisco CallManager Release 3.0, to permit visibility into the operation and reporting capability of a Cisco AVVID network. Table 35-1 lists the features provided for network management applications to export data and, particularly for CiscoWorks2000, to provide reporting, proactive management, and debugging capabilities.
Table 35-1 Remote Network Management Tools for Cisco CallManager
Tool
|
Description
|
Simple Network Management Protocol (SNMP)
|
Three Management Information Bases (MIBs) included with Cisco CallManager permit a network management system to extract appropriate information.
|
Cisco Discovery Protocol (CDP) Support (CDP MIB)
|
CDP discovers Cisco devices in a network. CDP enables discovery of Cisco CallManager servers and management of those servers by CiscoWorks2000.
|
System Log Management
|
Cisco Syslog Analysis streamlines the management of open, distributed systems by providing a common administrative interface for all log messages received from the application.
|
For more information on remote network management, refer to the Cisco CallManager Serviceability Administration Guide.
Call Detail Records
When CDR collection is enabled, Cisco CallManager writes call detail records (CDRs) to the SQL database as calls are made. CDR collection is enabled and configured through service parameters that are set in Cisco CallManager Administration. You must enable CDR collection on each Cisco CallManager in the cluster for which you want to generate records (see the "CDR-Related Service Parameters" section).
All CDR records are written to the local database on each Cisco CallManager and then moved from the local database to the publisher database for the cluster in a low priority thread at 1-minute intervals.
If the local database is not available, then they are written to any of the other subscriber databases in the cluster. When the local database becomes available, the writing of new records resumes on the local database.
Enabling CDR Collection
CDR collection is enabled through a Cisco CallManager service parameter named CdrEnabled. To enable CDR collection:
1. Open Cisco CallManager Administration.
2. Select Service > Service Parameters.
3. Click on the Cisco CallManager server on which you wish to enable CDR collection.
4. Select Cisco CallManager from the list of configured services.
5. Select CdrEnabled from the list of service parameters.
6. Choose T (true, CDRs enabled) or F (false, CDRs disabled) from the Value drop-down list box.
7. Repeat this procedure on each Cisco CallManager in the cluster. You do not need to restart the Cisco CallManager for the change to take effect.
CDR-Related Service Parameters
The following tunable service parameters apply to CDRs:
•MaxCdrRecords—Cisco TFTP service parameter that controls the maximum number of CDRs on the system. When this limit is exceeded, the oldest CDRs are automatically removed, along with the related CMR records, once a day. The default is 1.5 million records.
•CdrEnabled—Cisco CallManager service parameter that controls whether or not CDRs are generated.
•CdrLogCallsWithZeroDurationFlag—Cisco CallManager service parameter controls whether calls with zero duration are logged in CDRs. The default is False (zero duration calls not logged).
Removing CDR Records
The CallManager application relies on post-processing applications such as ART or other 3rd-party packages to analyze CDR data. The removal of the CDR data should be done by the administrator when all post-processing applications are through with the data. Because this involves modifying the database, the SQL user CiscoCCMCDR should be used.
If CDR records accumulate to a configured maximum (as set by the MaxCdrRecords service parameter, which defaults to 1.5 million records), then the oldest CDR records are removed along with related CMR records once a day.
When removing CDR data after analysis, be sure to remove all related CMR records also.
Tips It is best to remove CDR and CMR records often instead of once a day or week in a large system. Queries to remove records can consume CPU time and transaction log space relative to the size of the table. The smaller the table, the quicker the query. Large queries on a live database can adversely affect call processing.
CDR Database Access
The easiest way to read data from the SQL database is to use ODBC. A good connection string would look like one of the following examples depending on whether you need to get to the configuration data or CDRs:
DRIVER={SQL Server};SERVER=machineX;DATABASE=CCM0300
DRIVER={SQL Server};SERVER=machineX;DATABASE=CDR
Be sure to use the correct database name. Previous versions of the product had the CDR tables in the CCM0300 database. The tables have been moved to the CDR database. Also, you will need access to both the configuration database and CDR database to properly resolve the CDR information.
The machine that is the central collector of the CDR information is the machine serving the primary CCM0300 database. To determine the publisher database (machine and name) currently in use by the cluster, perform the following steps:
1. Choose Help > About Cisco CallManager.
2. Click the Details button.
The Database field in the Database Information area displays the name of the Cisco CallManager server that is the publisher database for the cluster.
Access to CDR records is controlled through SQL Users. Table 35-2 specifies the UserID and password that should be used when accessing the Cisco CallManager database.
Table 35-2 SQL Users for CDR Access
Database
|
Tables
|
SQl UserID
|
Password
|
Capability
|
CDR
|
CallDetailRecord, CallDetailRecordDiagnostic
|
CiscoCCMCDR
|
dipsy
|
Read/write access to CDR
Read access to CCM0300
|
CCM0300
|
All
|
CiscoCCMReader
|
cowboys
|
Read only
|
Where to Find More Information
Related Topics
•Cisco TFTP
•Understanding Cisco WebAttendant
•Understanding Voice Gateways
•Cisco IP Phones
•Call Admission Control
•System Configuration Checklist, page 4-11
Additional Cisco Documentation
•Device Defaults Configuration, Cisco CallManager Administration Guide
•Device Pool Configuration, Cisco CallManager Administration Guide
•Gateway Configuration, Cisco CallManager Administration Guide
•Cisco IP Phone Configuration, Cisco CallManager Administration Guide
•Cisco CallManager Group Configuration, Cisco CallManager Administration Guide
•Cisco JTAPI Installation and Configuration, Cisco CallManager Administration Guide
•Bulk Administration Tool Guide for Cisco CallManager
•Administrative Reporting Tool Guide for Cisco CallManager
•Cisco CallManager Serviceability Administration Guide