3.26 Report_CCME_StatsByEPhone

Use this Knowledge Script to summarize the call statistics for Cisco Communications Manager Express phones (ephones) based on configuration information retrieved by the CCME_GetConfig Knowledge Script. You must run GetConfig and the Data Collection job before you can run StatsByEPhone.

This report can summarize the following call statistics:

  • Communications Manager Express

  • Total Duration

  • Duration of Originated Calls

  • Completed Calls

  • Completion Rate

  • Total Calls

  • Originated Calls

  • Failed Calls

  • Success Rate

You can sort the rows in this report according to its various columns:

  • Directory Number

  • Duration of Originated Calls

  • Completion Rate

  • Duration of All Calls

  • Number of Originated Calls

  • Success Rate

NOTE:Unlike other modules, for the Call Data Analysis module, the Report agent pulls data from the Data Warehouse rather than from the AppManager repository. The Report agent uses Windows authentication to access the Data Warehouse.

3.26.1 Resource Object

Report agent

3.26.2 Default Schedule

By default, this script runs once.

3.26.3 Setting Parameter Values

Set the following parameters as needed:

Parameter

How to Set It

Data Source

Select data source

Select the data for your report by View Name, Data Warehouse, or Data Source. You may select only one H.323 RADIUS data source.

Select time range

Select a Specific or Sliding date/time range from which the report should pull data. The default is Sliding.

Minimum duration

Specify the minimum duration filter for calls selected by the script. The default is 0 seconds.

Exclude these failure codes

Type a list of termination codes (separated by commas) that are not to be considered failures. For more information, see Section 3.16.1, Termination Codes.

NOTE:Codes 0, 16, 31, 126, and 393216 are automatically excluded. They are normal termination codes. However, these codes may appear in events if the other side of the call has a failure code that has not been excluded.

Search Criteria

Note for entering search criteria: If you specify only the wildcard (*) for a field (such as calling number), AppManager matches only those calls that have a value for that field. Calls for which that field has no value (i.e., is NULL) will not be matched. For example, if you specify * in the Calling partition name parameter, the search matches only those calls that have some partition name configured. To match all calls (including calls that have no value for the selected field), leave the search criteria parameter blank.

Gateway name

Specify the name of the Communications Manager Express gateway for which you want to gather call statistics. Leave this field blank to gather statistics for all Communications Manager Express gateways.

Directory number

Specify the directory number for which you want to gather call statistics.

Device name

Specify the name of the device for which you want to gather call statistics.

Device IP address

Specify the IP addresses of the devices you want to find. Use one of the following formats:

  • Single dotted-decimal IP address, such as 10.41.2.31

  • Dotted-decimal IP address that includes a wildcard, such as 10.41.*.*, which would search for all IP addresses in the range of 10.41.0.0 to 10.41.255.255.

  • Range of dotted-decimal IP addresses separated by a hyphen, such as 10.41.2.31-10.41.2.41. The first address indicates the beginning of the range; the second IP address marks the end of the range.

Report Settings

Order rows by?

Select the column by which you want to sort the rows in the report. The default is DirectoryNumber.

Include parameter help card?

Set to y to include a table in the report that lists parameter settings for the report script. The default is y.

Select output folder

Set parameters for the output folder. The default folder name is CCME_StatsByEPhone.

Add job ID to output folder name?

Set to y to append the job ID to the name of the output folder. The default is n.

A job ID is helpful for making the correlation between a specific instance of a Report script and the corresponding report.

Select properties

Set miscellaneous report properties as desired. The default report name is Cisco CME Call Statistics By EPhone.

Add time stamp to title?

Set to y to append a time stamp to the title of the report, making each title unique. The default is n. The time stamp is made up of the date and time the report was generated.

Adding a time stamp is useful in order to run consecutive iterations of the same report without overwriting previous output.

Event Notification

Raise event if report succeeds?

Set to y to raise an event when the report is successfully generated. The default is y.

Event severity when report succeeds

Set the severity level, from 1 to 40, to indicate the importance of an event in which the report is successful. The default is 35.

Event severity when report has no data

Set the severity level, from 1 to 40, to indicate the importance of an event in which the report contains no data. The default is 25.

Event severity when report fails

Set the severity level, from 1 to 40, to indicate the importance of an event in which the report fails. The default is 5.