cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3266
Views
20
Helpful
0
Comments
Gerson Fabian Morales Marin
Community Member

 

Verification of tables on CLI

SQL Query
"run sql car select * from car:tbl_system_preferences"

This output shows the current configuration on the Call Manager Publisher

admin:run sql car select * from car:tbl_system_preferences
param_name param_value
========================= ========================================
MIN_DATE 11/09/2014
MAX_DATE 01/06/2015
LAST_PROCESSING_DIRECTORY
CDR_MIN_DATE 11/09/2014
MAX_CDR_NUMBER 2000000
MAX_ERROR_RECORD_ID 191255
COMPANY_NAME
TOLL_FREE 1800,1855,1866,1877,1888
CHARGELIMIT 200.00
GOOD 20.00
POOR 30.00
DEFAULT_CAR_USER _unspecifieduser
LOADER_STATUS 1
CONTINUOUS_LOADING_24_7 1
LOAD_CDR_ONLY 1
MANUAL_PURGE_STATUS 0
LOADER_SCHEDULE_BACKUP DailyCdrLoad,L,1440,-1,00:00:00,0,300,30
PURGE_LOW_WATER_MARK 80
PURGE_HIGH_WATER_MARK 90
MIN_CAR_DATABASE_AGE 2
MAX_CAR_DATABASE_AGE 60
LAST_PROCESSING_FILE
LAST_PROCESSING_DATA_ROW
CDR_MAX_DATE 01/06/2015
UPDATE_STATISTICS_DATE 01/06/2015,0
LOADER_BATCH 600,600,2500,3000
HUNTPILOT_VALUE 1
TIMEZONE_FOR_CDRSEARCH 2
CCM_SERVERNAME cvxs_1_cm_ccm10_5_1_11900_13
INSTALLATION_DATE 11/13/2011

Restore CDR tables back to default (Publisher)

Commands
run sql car update tbl_system_preferences set param_value='2000000' where param_name='MAX_CDR_NUMBER'
run sql car update tbl_system_preferences set param_value=' ' where param_name='COMPANY_NAME'
run sql car update tbl_system_preferences set param_value='1800,1855,1866,1877,1888' where param_name='TOLL_FREE'
run sql car update tbl_system_preferences set param_value='200.00' where param_name='CHARGELIMIT'
run sql car update tbl_system_preferences set param_value='20.00' where param_name='GOOD'
run sql car update tbl_system_preferences set param_value='30.00' where param_name='POOR'
run sql car update tbl_system_preferences set param_value='_unspecifieduser' where param_name='DEFAULT_CAR_USER'
run sql car update tbl_system_preferences set param_value=' ' where param_name='LOADER_SCHEDULE_BACKUP'

 

Note: Some times you will see that the Min date and Max date are not correct as the following output shows


MIN_DATE                  02/11/2015                                
MAX_DATE                  02/12/2015                                
CDR_MIN_DATE              02/11/2015                                
CDR_MAX_DATE              02/12/2015                                
MAX_CDR_NUMBER            2000000                                   
MAX_ERROR_RECORD_ID       119561992                                 
COMPANY_NAME                                                        
TOLL_FREE                 1800,1855,1866,1877,1888                  
CHARGELIMIT               200.00                                    
GOOD                      20.00                                     
POOR                      30.00                                     
DEFAULT_CAR_USER          _unspecifieduser                          
LOADER_STATUS             1                                         
CONTINUOUS_LOADING_24_7   1                                         
LOAD_CDR_ONLY             1                                         
MANUAL_PURGE_STATUS       0                                         
LOADER_SCHEDULE_BACKUP    DailyCdrLoad,L,1440,-1,09:07:00,0,0,1440  
PURGE_LOW_WATER_MARK      80                                        
PURGE_HIGH_WATER_MARK     90                                        
MIN_CAR_DATABASE_AGE      2                                         
MAX_CAR_DATABASE_AGE      60                                        
LAST_PROCESSING_DATA_ROW  600                                       
LAST_PROCESSING_FILE      cdr_NDCCucmCluster_02_201502121818_169247
LAST_PROCESSING_DIRECTORY 20150212                                  
UPDATE_STATISTICS_DATE    02/13/2015,0                              
LOADER_BATCH              600,600,2500,3000                         
HUNTPILOT_VALUE           1                                         
TIMEZONE_FOR_CDRSEARCH    1                                         
CCM_SERVERNAME            xnzxpap210x_ccm8_6_2_24901_1              
INSTALLATION_DATE         10/3/2012                                 

Recommended configuration Min_Date and Max_Date

run sql car update tbl_system_preferences set param_value = '12/17/2014' where param_name = 'MIN_DATE'
run sql car update tbl_system_preferences set param_value = '12/17/2014' where param_name = 'CDR_MIN_DATE'
run sql car update tbl_system_preferences set param_value = '02/13/2015' where param_name = 'MAX_DATE'
run sql car update tbl_system_preferences set param_value = '02/13/2015' where param_name = 'CDR_MAX_DATE'

 Restart services on Call Manager

1- Go ahead and complete a manual purge on the CDR web page.

Cisco Unified Serviceability-->Tool-->CDR Analisis and reporting-->System-->Data Base-->Manual purge-->Purge.

2- Make sure that the Service Parameter CDR flag  is "True"

3- Cisco CAR Web Service "Restart"

4- Cisco CAR Scheduler "Restart"

5- Cisco CDR repositiry Manager "Restart"

6- Cisco CDR Agent "Restart"

 

Results

Make a test call and get the call records needed

After following the steps above you will be ready to place a test call and use the CDR analysis and reporting tool to find the records that customer needs.

Enjoy it!

Regards,

Gerson Fabian Morales Marin (gersomor)

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links