As its primary function, CAR generates reports about the
Cisco Unified Communications Manager and generates reports on the system
status with respect to call processing. CAR also performs CAR database
management activities. You can perform these tasks in one of the following
You access CAR from the Tools menu of
Cisco Unified Serviceability after you activate the appropriate services as
described in the
All CAR reports use CDR data. CAR processes the CDRs from
flat files that the CDR Repository service places in the CDR repository folder
structure. CAR processes CDRs at a scheduled time and frequency. By default,
CDR data loads continuously 24 hours per day and seven days per week; however,
you can set the loading time, interval, and duration as needed. In addition,
the default setting loads only CDR records. CMR records do not get loaded by
An option allows you to uncheck the
"Load CDR Only" check box in the CAR System Scheduler window to
allow CMR records to load. See
Set Up CDR Load Schedule
for additional information.
CAR retrieves information that is required for various
reports from CDRs, CMRs, and the
Cisco Unified Communications Manager database.
After CAR is activated on your system, you can schedule CAR
reports to generate automatically at a regular time. Each report that can be
scheduled has its own report generation interval. You can make the report
generation interval be daily, weekly, or monthly. Scheduling Daily reports
schedules all the reports that have report generation intervals of daily.
Similarly, scheduling Weekly or Monthly reports would schedule the reports that
have report generation intervals of weekly or monthly. You can also specify the
time to keep a report before it gets automatically deleted.
By default, CAR uses the following report generation and
Daily reports run at 1 a.m. every day. These reports get purged
after two days.
Weekly reports run at 4 a.m. every Sunday. These reports get
purged after four weeks.
Monthly bill reports run at 3 a.m. on the first day of every
month. These reports get purged after two months.
Other monthly reports run at 2 a.m. on the first day of every
month. These reports get purged after two months.
If you upgrade your system to a new version of
Cisco Unified Communications Manager, you must disable the CAR reports that
generate automatically, so you conserve system resources during the upgrade
For a list of reports and the default generation schedule,
Enable Automatic Generation Reports.
For system monitoring, automatically generate various
reports, such as QoS reports, and review them at regular intervals, perhaps
every day if you have a very large system, or every week or every two weeks for
smaller systems. QoS reports help you determine the quality of calls that run
on your network and judge whether you need additional hardware to improve
performance. You can use utilization reports for gateways, voice messaging,
conference bridge, route groups, route lists, and route patterns to provide a
picture of the usage to help with system handling.
You can also customize the report parameters and enable a
mailing option, so reports get emailed when they are created. The Customize
Parameters option allows you to customize the report parameters for particular
reports in the Customize Parameters window. For each individual report, you can
customize the parameters for that report.
Setting Up Alerts
CAR provides email alerts for various events, including the
Charge Limit Notification indicates when the daily charge limit
for a user exceeds the specified maximum. You can set the maximum in the
QoS Notification indicates when the percentage of good calls drops
below a specified range or the percentage of poor calls exceeds a specified
limit. You can set the range in the
Report Config > Notification Limits window.
Enabling the system for email alerts comprises a two-step
process. First, you must specify the mail server configuration information
CAR uses the configuration information to successfully connect to the email
server. Next, you must enable the email alerts on the Automatic Report
Generation/Alert window ( ). By default, CAR enables email
alerts for some, but not all, reports.
Be sure to disable the automatic email alerts to conserve
system resources while you upgrade your system to a later version of
Cisco Unified Communications Manager.
The system does not provide email alerts to application users
because no mail ID exists for an application user.
Purging CAR Data
This section contains information on the following topics:
Event log purging
CAR provides automatic and manual purging of the CAR
database. By default, the system enables automatic purging. Before and after
loading CDRs/CMRs, CAR checks the size of the CAR database and invokes
automatic purging, if necessary, to control the CAR database size.
With automatic purging, CAR continuously monitors the number
of days that the CDRs are kept in the CAR database; when the CDR age exceeds
the maximum number of days as configured in the maximum age setting in the
Configure Automatic Database Purge window, CAR deletes all CDRs that are older
than the number of days that you configured.
In the Configure Automatic Database Purge window, you specify
the percentages of the CAR database that you want to allot for CAR data; the
system maintains the CAR database size between the high water mark and low
water mark that you specify. When the CAR database size exceeds the low water
mark, CAR sends an email to CAR administrators. When the CAR database size exceeds the high water mark, CAR begins to delete the partitions from billing data and billing error tables, starting from the oldest date partitions until under the specified limit, allowing the system to continue loading the latest records. In cases where there are a large number of CDRs present in the CAR database and deleting the partitions does not lower the limit, CAR will keep at least two days worth of data and send an email to CAR administrators.
Table 1 Maximum Size of CDR Database
Maximum Number of CDR Records
Maximum Size of Database
Maximum Aggregate Busy Hour Call Attempts (BHCA)
Cisco Unified Communications Manager
2 million records
Cisco Unified Communications Manager Business Edition
1 million records
Configure manual database purge when you want to delete
records that are older than a particular date or that fall in a specific date
range, but you do not want to change the automatic purging schedule. You can
also reload the CAR database with CDR records by clicking the Reload button in
the Manual Purge window. You may want to reload the database to reclassify
calls after dial-plan updates, user-device association changes, call rate
changes, and so on. After the system loads the new records, the system loads
the records according to the schedule in the configured CDR load schedule. By
default, CDR data loads 24 hours per day, 7 days per week.
Event log purging, which is a daily scheduled job that
monitors the tbl_event_log table, automatically deletes the tbl_event_ log
records to keep the latest 3 days of daily jobs, the latest 3 weeks of weekly
jobs, and the latest 3 months of monthly jobs; that is, if more than 1500 rows
exist in the tbl_event_log table, CAR automatically enables event log purging
and does not send an e-mail when event log purging occurs.
You can use CAR to set a base monetary rate for the cost of
calls on the basis of a time increment. Then, you can further qualify the cost
by applying the time-of-day and voice-quality factors. Service providers who
must account for service to subscribers use this feature. Some organizations
also use this information to establish billing costs for users and departments
in the organization for accounting or budgeting purposes.
Reports that use these rating parameters include Individual
Bill, Department Bill, Top N by Charge, Top N by Number, and Top N by Duration.
If you do not change the default value for charge base/block, the
cost will always remain zero because the default base charge per block equals
If you do not want to increase call cost by voice quality, you can
use the default values. The default multiplication factor specifies 1.00, so no
increase in call cost for voice quality occurs.
For more information on setting call rates, see
CAR Rating Engine.
CAR provides logs that can track the status of the various
activities. The event log tracks events that the CAR Scheduler triggers, such
as automatically generated reports, loading of CDRs, notifications, report
deletions, database purging and monitoring, and event tracking.