Use this Knowledge Script to search for call detail records (CDRs) retrieved from the primary Communications Manager and stored in the local SQL database. The search is based on query filters you select. This script raises an event if no CDRs are found or if the number of CDRs found exceeds the threshold you set. In addition, this script generates a data stream for the number of records found.
This script provides the following features:
Monitoring. In monitoring mode, this script checks the CDR tables at each specified interval for new records that match your query. In the first iteration of the job, this script finds the last record in the CDR table and checks back one interval from there. In subsequent iterations, this script checks for new records that match the query in each interval.
Troubleshooting. In troubleshooting mode, this script runs once and checks the CDR tables for calls whose disconnect time is within the range you select in the Select call disconnect time range parameter.
To run this script in troubleshooting mode, select Run once on the Schedule tab.
CiscoCM_CDRMgmt
By default, this script runs every five minutes.
Set the following parameters as needed:
Parameter |
How to Set It |
---|---|
General Settings |
|
Job Failure Notification |
|
Event severity when job fails |
Set the event severity level, from 1 to 40, to indicate the importance of the failure of the CDR_Query job. The default is 5. |
Raise event if no records found? |
Select Yes to raise an event if there are no CDRs to monitor. Note that we do not mean there are no CDRs with call quality data, but that there are no CDRs at all. The default is unselected. |
Event severity when no records found |
Set the event severity level, from 1 to 40, to indicate the importance of an event in which no CDRs were found. The default is 25. |
Query Filters Despite the number of calls AppManager might find that match the filters you select, an event displays only the first 50 calls. |
|
Minimum duration |
Set this parameter to filter out records whose call duration is less than the specified value. Accept the default of 0 to ignore the filter for minimum call duration. |
Maximum duration |
Set this parameter to filter out records whose call duration is less than or equal to the specified value. Accept the default of 0 to ignore the filter for maximum call duration. |
Calling directory number |
Specify the number of the calling directory you want to find in the CDRs. Wildcard characters are acceptable. Leave this parameter blank to search for any calling directory number. |
Directory number connector |
Set this parameter ONLY if you specify both a Calling directory number and a Called directory number. Your selection indicates how the script will connect the two parameters: AND or OR. The default is AND. |
Called directory number |
Specify the number for the called directory you want to find in the CDRs. Wildcard characters are acceptable. Leave this parameter blank to search for any called directory number. |
Called directory number type |
Select the type of called directory number you want to find in the CDRs. You can filter the CDRs by the originally called directory number, the most recently called directory number, or by either directory number. The default is either directory number. |
Originating device name |
Set this parameter to query for those calls whose originating device name matches the specified value. Wildcard characters are acceptable. Leave this parameter blank to search for any originating device name. |
Device name connector |
Set this parameter ONLY if you specify values for both the Originating device name and Destination device name parameters. Your selection indicates how the script will connect the two parameters: AND or OR. The default is AND. |
Destination device name |
Set this parameter to query for those calls whose destination device name matches the specified value. Wildcard characters are acceptable. Leave this parameter blank to search for any destination device name. |
Troubleshooting |
|
Select call disconnect time range |
Select a Specific or Sliding date/time range for which the query should search for data. The default time range is fixed at 24 hours. NOTE:This parameter is valid only when you select Run once on the Schedule tab. |
Call time range type |
Select the type of call time range you want to use when troubleshooting. The time ranges can match on the following options:
The default is DisconnectTime. NOTE:This filter will only work if you schedule the script to Run Once. |
Monitor Records Found |
|
Event Notification |
|
Raise event if number of records exceeds threshold? |
Select Yes to raise an event if the number of CDRs found exceeds the threshold. The default is Yes. |
Threshold - Maximum number of records |
Specify the maximum number of CDRs that can be found before an event is raised. The default is 0 CDRs. |
Event severity when number of records exceeds threshold |
Set the event severity level, from 1 to 40, to indicate the importance of an event in which the number of CDRs found exceeds the threshold. The default is 15. |
Data Collection |
|
Collect data for number of records? |
Select Yes to collect data for charts and reports. If enabled, data collection returns the number of CDRs found during the monitoring period. The default is unselected. |