McDewey

Both the Purge button and the Reload All Call Detail Records button get disabled, and the following alert message displays on the Manual Purge window, when either a manual purge or CDR reload occurs: Manual Purge/Reload is still running. User will not be allowed to run another instance of Manual Purge/Reload. So, both Purge and Reload All Call Detail Records buttons are disabled. Procedure Step 1 Choose System > Database > Manual Purge. The Manual Database Purge window displays. Step 2 Choose one of the following actions: a) To delete the existing CAR data and reload the CAR database, click Reload All Call Detail Records. The system displays a message that indicates that deleting the records may impact system performance. To continue the reload process, click OK. The system begins loading the CDRs into the CAR database within 5 minutes and continues uninterrupted for up to 6 hours. To monitor the progress of the reload, generate the CDR Load event log. After the system loads the new records, the system loads the records according to the schedule that is configured. By default, CDR data loads 24 hours per day and 7 days per week. b) To manually purge selected CAR records, continue with the next step. Step 3 In the Select Table field, choose the table in the database that you want purged. To view the tables for which manual purge is permitted, the total number of records in the table, and the latest record and oldest record in the table, click Table Information. The Table Information window displays. You will see a table with the following information: Oldest Record Latest Record Total No. of Records Table Name Database Name 0 0 0 Tbl_billing_data CAR 0 0 0 Tbl_billing_error CAR 0 0 0 Tbl_purge_history CAR To return to the Manual Database Purge window, click Close. Step 4 In the Delete records field, choose a date that will determine which records will be purged by clicking one of the following radio buttons: a) Older than - Choose a date for which all records before that date will be deleted. b) Between - Choose a range of dates between which all records will be deleted. Step 5 Choose the date range of the CAR records that you want to delete. Step 6 To delete all records older than or between the dates that you specified, click Purge. A prompt advises you that you are about to permanently delete the specified records. Step 7 To purge the records, click OK or click Cancel to abort the purge operation. Call Reporting and Billing Administration Guide for Cisco Unified Communications Manager, Release 15 and SUs 44 CDR Analysis and Reporting Purge CAR Database