Cisco IP Telephony Troubleshooting Guide for Cisco CallManager Release 3.0(1)

The primary database (machine and name) currently in use by the cluster can be found by clicking on the Details button of Cisco CallManager Administration (click Help to reach the Welcome screen where the Details button is located). The registry on machines hosting a database can also be checked. Look at the registry key:

“\\HKEY_LOCAL_MACHINE\Software\Cisco Systems Inc.\DBL” for the item called DBConnection0. This string item contains a connection string similar to that shown above with the machine name and database name of the primary database.

Access is controlled by use of SQL Users. The following table specifies the UserID and password that should be used when accessing the Cisco CallManager database.

Tables

CallDetailRecord, CallDetailRecordDiagnostic

(Other)

Removing Records

SQl UserID

CiscoCCMCDR

CiscoCCMReader

Password

dipsy

cowboys

Capability

Read/Write

Read only

Since Cisco CallManager is relying on third party applications to post-process the CDR data, you should remove the CDR data when all applications are through with the data. Since this involves modifying the database, the CiscoCCMCDR user should be used.

If CDR records accumulate to a configured maximum (10,000,000 CDR records), then the oldest CDR records will be removed along with related CMR records once a day.

When removing CDR data after analysis, be sure to remove all related CMR records also.

Table Schema

Detailed information about the format and use of each field in the CDR is provided later in this appendix.

The main tables to be used are the CallDetailRecord table, which holds CDR records, and the CallDetailRecordDiagnostic table, which holds CMR records. The CallDetailRecord table is related to the CallDetailRecordDiagnostic table via the two GlobalCallID columns, GlobalCallID_callManagerId and GlobalCallID_callId. There may be more than one CMR per CDR.

The CallDetailRecord table holds information about the endpoints of the call and other call control/routing aspects of the call. The CallDetailRecordDiagnostic table holds information about the quality of the streamed audio of the call.

© 2000 Cisco Systems, Inc.

78

Page 77 Page 79
Page 78
Image 78
Cisco Systems 30 VIP manual Removing Records, Table Schema
Page 77 Page 79

30 VIP specifications

Cisco Systems has been a leading company in networking technology, and its suite of products is continually evolving to meet the demands of modern digital infrastructure. One of the latest introductions is the Cisco Systems 30 VIP, a highly advanced solution designed to enhance network performance and security for businesses of all sizes.

The Cisco Systems 30 VIP stands as a cornerstone for next-generation networking features, providing organizations with significant advantages in speed, reliability, and scalability. At the heart of the 30 VIP are key technologies such as advanced routing protocols and enhanced security measures that ensure seamless data transfer across multiple devices.

Main features of the Cisco Systems 30 VIP include its high throughput capabilities, which support accelerated data processing and lower latency. This is crucial for businesses that rely on real-time data exchange and cloud applications. Additionally, the device incorporates Multi-Protocol Label Switching (MPLS) technology, which optimizes data flow between networks and significantly enhances overall performance.

Another notable characteristic of the 30 VIP is its integrated security features, including advanced threat detection and prevention systems. These are designed to protect sensitive business data from cyber threats, ensuring operational continuity and compliance with industry regulations. The Cisco 30 VIP also supports secure access protocols, allowing for secure remote connections, which is increasingly vital in today’s hybrid work environment.

The adaptability of the Cisco Systems 30 VIP is another of its standout aspects. It offers compatibility with existing Cisco infrastructure, making it easier for businesses to adopt new technologies without overhauling their entire system. This modular approach allows for easy upgrades and integration of future technologies, ensuring long-term viability and investment protection.

Furthermore, the Cisco Systems 30 VIP is powered by intelligent network management software that simplifies monitoring, configuration, and troubleshooting processes. This software enhances network visibility, allowing administrators to identify and address potential issues proactively, thereby reducing downtime and enhancing user experience.

In summary, the Cisco Systems 30 VIP represents a significant advancement in network technology with its high throughput, integrated security features, adaptability, and intelligent management capabilities. These elements combine to provide a robust solution that meets the evolving needs of modern businesses while ensuring secure and efficient operations. As organizations continue to navigate an increasingly complex digital landscape, the Cisco Systems 30 VIP offers a future-proof option designed to facilitate growth and resilience.
Top Page Image Contents