4.15 CDR_Query

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.

4.15.1 Resource Object

CiscoCM_CDRMgmt

4.15.2 Default Schedule

By default, this script runs every five minutes.

4.15.3 Setting Parameter Values

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:

  • Origination time of calls

  • Disconnect time of calls

  • Either origination or disconnect time

  • Both origination and disconnect time

  • All calls that span some portion of the time range, including calls that started before the range, and calls that ended after the range.

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.