Cisco Systems 30 VIP manual Removing Records, Table Schema

Page 78

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
Image 78
Page 77 Page 79
Contents SDI Trace Output Configuring Traces Reorder Tone Through Gateways Gateway Registration Problems Page Purpose Documentation Checklist Cisco IOS Cluster Acronym/Term Cnf Law mu-lawChannel Calling Search Space CCAPi Codec ChannelFlow Full duplex 711 729 225 245 323 Half Duplex Hookflash Jitter Law mu-lawPartition 931 Route Filter Route Group Route List Route PatternSilence Suppression Voice Activation Detection Translation Pattern Voice Activation Detection Silence Suppression VoIPCisco CallManager Administration Details Microsoft Performance View ReportMicrosoft Event Viewer SDI Trace Configuring Traces SDL Trace Page SDLTraceTypeFlag Value Definition SDLTraceDataFlag ValueSniffer Trace Call Detail Records CDR and Call Management Records CMRSelect Service Service Parameters CDRs Problem Categories Voice QualityPage Packet Number Time absolute ms Time delta ms Button Help John Check Your Loads Phone Resets Dropped Calls Page Page Cisco CallManager Feature Issues Locations Conf Bridge Region1 Region2 MTP Resource Problems MTP Dial Plans Dialing DOES-NOT-EXIST Page Name DialPlanWizardG ClausePattern Partition Pattern Device Name Device Description UsageSlow Server Response Reorder Tone Through GatewaysGateway Registration Problems CFG Booting Dhcp for dynamic configuration Module.portTracyclose mod port tracystart mod port TaskID Cmd show dhcp Gmsg ***TFTP Error File Not Found Gatekeeper Problems Gmsg CCM#0 CPEvent = Loadid -- CPState = LoadResponseRegistration Rejects RRJ Sample Topology Cisco IP Phone Initialization ProcessPage Skinny Station Registration Process Station IP Port Station ResetMessage Description Station Register AcknowledgePage Cisco CallManager Initialization Process Self-Starting Processes Cisco CallManager Registration Process Cisco CallManager KeepAlive Process Cisco CallManager Intra-Cluster Call Flow Traces Cisco Systems, Inc CCMStationD stationOutputStopTone tcpHandle=0x4fbbc30 Cisco Systems, Inc Call Flow Traces Page Cisco Systems, Inc Following debug messages show that the call is in progress Debug Messages and Show Commands on the Cisco IOS Gateway Gatekeeper Endpoint RegistrationCisco Systems, Inc Page Cisco IOS Gateway with T1/PRI Interface Cisco IOS Gateway with T1/CAS Interface Cisco Systems, Inc Inter-Cluster H.323 Communication Call Flow Traces Failed Call Flow Cisco Systems, Inc Writing Records Reading RecordsTable Schema Removing RecordsKnown Issues Fields in a Call Detail RecordDeciphering the Time Stamp Date/time of call origination Global Call IdentifierOrigination leg call identifier Originator’s node IDIP address for the originator’s media connection Isdn location valueCalling party cause Of call termination Port for the originator’s media connectionIP port to which the call was delivered Destination span or portIP address to which the call was delivered unsigned integer Called party’s partitionDate/time of connect IP address for the destination outgoing media connectionCodec type used by the destination on sending side Date/time of disconnect unsigned integerCall Identifier Global Call Identifier for this callCisco CallManager node identifier Directory number used on this callLost RTP packets during this connection Interarrival jitter during this connectionLatency experienced during this connection Normal Calls Cisco IP Phone-to-Cisco IP Phone Call Management Records Logged By Call Type Codec Types Compression / Payload types Codec Cause Codes DescriptionNumber changed Alarms Calling Cisco Technical Assistance Center TAC Index Debug messages and show commands Page Topology

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