Cisco Unified CallManager Serviceability Administration Guide, Release 4.2(3) - CDR Analysis and Reporting [Cisco Unified Communications Manager (CallManager)]

Table Of Contents

CDR Analysis and Reporting

Installing the CAR Plug-in

Uninstalling the CAR Plug-in

Configuring CDR Service Parameters

Accessing the Initial User ID and Password

Loading CAR

Administrator Procedure

Administrator and User Procedure

Logging On to CAR

Logging Out of CAR

Viewing About CAR

CDR Analysis and Reporting

The Cisco Unified CallManager CDR Analysis and Reporting (CAR) tool generates reports of information for quality of service, traffic, user call volume, billing, and gateways.

Note CAR does not handle iDivert calls (feature to divert calls to voice- messaging system) and treats them as normal calls. The part of the call after iDivert feature gets activated may not get charged to the correct party.

This chapter contains the following topics:

•Installing the CAR Plug-in

•Uninstalling the CAR Plug-in

•Configuring CDR Service Parameters

•Accessing the Initial User ID and Password

•Loading CAR

•Logging On to CAR

•Logging Out of CAR

•Viewing About CAR

Note You can view CAR reports in either PDF or CSV format. PDF format limits the number of records in the CAR reports to 5000, and CSV format limits the records to 20,000. If the number of records exceeds these limits, a message displays to inform you that the results are truncated. To avoid this, you can reduce the date range and generate the reports, or, if you are using PDF format, you can use CSV format instead.

Installing the CAR Plug-in

This section describes how to install the Cisco Unified CallManager CDR Analysis and Reporting (CAR) plug-in with Cisco CallManager Release 3.2 and above. For more information about upgrading Cisco Unified CallManager, refer to the latest version of the Upgrading Cisco Unified CallManager document.

Note If you have Cisco Unified CallManager CDR Analysis and Reporting (CAR), formerly known as Administrative Reporting Tool (ART), running on your system before upgrading to a new version of Cisco Unified CallManager, the upgrade process automatically upgrades CAR. If you are installing Cisco Unified CallManager for the first time or if you are upgrading and do not already have CAR running in the system, you must install CAR from the Install Plugins window.

During the CAR installation, the following message may display:

Password phrase is not correct. Click OK to re-enter the Private Password phrase. Click Cancel to go ahead with install, but CAR Scheduler service will not start.
If this message displays, run the Admin Utility to reset the Private Password phrase. To obtain the Admin Utility, navigate to C:\Program Files\Cisco\Bin on the publisher database server. Before you use the utility, review the readme documentation that is available in the same directory as the utility.

Procedure

Step 1 Open Cisco Unified CallManager Administration by choosing Start > Programs > Cisco Unified CallManager > CallManager Administration and log in with administrative privileges.

Step 2 Choose Applications > Cisco Unified CallManager Serviceability.

Step 3 In Cisco Unified CallManager Serviceability, choose Applications > Install Plugins.

Step 4 Click the icon next to the Cisco Unified CallManager CDR Analysis and Reporting (CAR) plug-in.

Step 5 Choose whether you want to run the program from its current location or to save the program to disk.

Note Install CAR only on the publisher database server.

Step 6 Click OK.

Tip CAR uses the Cisco Tomcat service that is installed by Cisco Unified CallManager, so ensure that the Cisco Tomcat service is running. While installing/uninstalling CAR, you cannot access other applications that use the Cisco Tomcat service because the CAR installation/uninstallation temporarily stops this service.

Related Topic

•Uninstalling the CAR Plug-in

Uninstalling the CAR Plug-in

You can uninstall CAR from the Add/Remove programs application in your Control Panel. This section describes how to uninstall CAR.

Procedure

Step 1 From the Start menu, choose Settings > Control Panel.

The Control Panel window displays.

Step 2 Double-click the Add/Remove Programs icon.

The Add/Remove Programs window displays.

Step 3 Scroll down until you locate the CDR Analysis and Reporting tool and click Change/Remove.

Related Topics

•Installing the CAR Plug-in

•Chapter 10 "Quality Report Tool", Cisco CallManager System Guide

Configuring CDR Service Parameters

CAR requires that CDR records be available in the CDR database of the primary CDR server. To ensure that CAR functions properly, change the default values for CDR service parameters.

Note Because the default values for the service parameters CDREnabled and CallDiagnosticsEnabled are disabled, you must enable these service parameters to make CDR records available to CAR.

To write the CDR records to a CDR database, configure the service parameters as described in Table 15-1.

Table 15-1 CDR Service Parameters

Parameter Name

Parameter Value

LocalCDRPath

Include a valid pathname.

Primary CDRUNCPath

Include a valid pathname.

CDRFormat

Enter the value Database.

PrimaryCDRDSN

Specifies a directory service number that points to the primary CDR server.

CDREnabled

Enable this service.

CallDiagnosticsEnabled

Enable this service.

Accessing the Initial User ID and Password

Only CAR administrators have administrative privileges on CAR. Individual users can log on to CAR by using the user ID and password that they use to access Cisco Unified CallManager Administration; however, only a CAR administrator can grant administrative privileges. The initial logon to CAR requires the use of a specific user ID and password.

Note To grant administrative privileges to users, you must first log on to CAR by using admin as the initial user name and password. Log on to CAR by using this user name and password to grant CAR administrator rights to user(s) for the first time. This user ID and password will only work when no CAR administrators are configured in the system. After one or more users is granted administrator rights, this initial logon (admin, admin) is disabled. At this point, only CAR administrators (users who have been granted administrator rights initially by using admin, admin,) can grant CAR administrator rights to other users.

See the "Granting Administrator Rights" section, for information on how to grant users administrative privileges.

Loading CAR

Administrators access CAR from the Tools menu in Cisco Unified CallManager Serviceability. When the CAR main menu displays, you must log in to CAR. The user profile in Cisco Unified CallManager Administration determines the user ID and password for CAR. See the "Accessing the Initial User ID and Password" section.

CAR supports three types of users: system administrators, individuals, and managers.

Permission levels provide the basis for access to CAR reports:

•Individual users can view or generate bills pertaining to their own phone calls.

•Managers can view reports and bills pertaining to all users within their group.

•CAR system administrators can use all the features.

Administrator Procedure

This section describes how administrators load CAR. Cisco Unified CallManager Serviceability lists CAR under the Tools menu item.

Procedure

Step 1 From Cisco Unified CallManager Administration, choose Application > Cisco Unified CallManager Serviceability.

The Cisco Unified CallManager Serviceability window displays.

Step 2 Choose Tools > CDR Analysis and Reporting.

The tool displays.

Note You must provide managers and individual users with a web address that they can use to browse into CAR.

Step 3 Log on to CAR. See the "Logging On to CAR" section.

Related Topics

•Accessing the Initial User ID and Password

•Administrator and User Procedure

•Logging On to CAR

•Logging Out of CAR

Administrator and User Procedure

This section describes how administrators and users load CAR. Administrators can also load CAR from the Serviceability main window. See the "Administrator Procedure" section.

Procedure

Step 1 From the web browser, enter https://<Server-ip/name>/art/Logon.jsp.

Step 2 Log on to CAR. See the "Logging On to CAR" section.

Related Topics

•Accessing the Initial User ID and Password

•Administrator Procedure

•Logging On to CAR

•Logging Out of CAR

Logging On to CAR

This section describes how to log on to CAR.

Procedure

Step 1 In the CAR logon window, enter your user ID in the User Name field.

Step 2 In the Password field, enter your password.

If the user ID or password are invalid, CAR displays the message, "Invalid Logon. Either the User Name or Password entered is invalid. Click here to try again." Enter another user ID or password and click OK.

The CAR window displays.

Related Topics

•Accessing the Initial User ID and Password

•Loading CAR

•Logging Out of CAR

Logging Out of CAR

This section describes how to log out of CAR.

Procedure

Step 1 In the CAR window, choose Logout.

Step 2 You are prompted with the message "For security reasons, it is advisable to close the browser window on Logout. Do you want to close the browser window?" Choose whether you want to close the browser window. If you click OK, the CAR window (browser) closes; otherwise, the CAR Logon window displays.

Related Topics

•Accessing the Initial User ID and Password

•Loading CAR

•Logging On to CAR

Viewing About CAR

This section describes how to view the About CAR information.

Procedure

Step 1 From the CAR window, choose Help > About CAR.

Step 2 Click the Details button.

The About window displays the following information:

Note When reporting or troubleshooting a problem, give the following information to Technical Assistance.

•CDR Analysis and Reporting version: X.X (where Xs equal version numbers)

•Database Information

–Driver:sun.jdbc.odbc.JdbcOdbcDriver

–Server:<server name>

–Name:art

–Version:X.X(X) (where Xs equal version numbers)

•Third party software

–Tomcat: X.X.X Apache (where Xs equal version numbers)

–JRE: X.X.X_XX Sun Microsystems (where Xs equal version numbers)

–StyleReport: X.X InetSoft Corp. (where Xs equal version numbers)

Step 3 To close the window, click the OK button.