IBM R2E2 manual Bulk input file name, Bulk input file schema

Chapter 2: Devices and Services

The Cisco IP Telephony Technology Pack provides a file that interprets these bulk input files. See Bulk adaptor design files on page 11 for more information.

Bulk input file name

Cisco IP Telephony devices produce Comma-Separated Values (CSV) files that are named using the following syntax:

DataType_ClusterName_Date_SerialNumber.csv

where:

•DataType specifies the type of data collected: cdr, cmr, cdrcmr, or perfmon.

•ClusterName specifies the name of the cluster from which the data was collected.

•Date specifies the date on which the data was collected. The date format is as follows: yyyyMMddHHmm

where:

—yyyy specifies a four-digit integer (for example, 2010) that identifies the year in which the Cisco IP Telephony produced the CSV file.

—MM specifies a two-digit integer (for example, 05) that identifies the month in which the Cisco IP Telephony produced the CSV file.

—dd specifies a two-digit integer (for example, 15) that identifies the day in which the Cisco IP Telephony produced the CSV file.

—HH specifies a two-digit integer (for example, 08) that identifies the metric hour in which the Cisco IP Telephony produced the CSV file.

—mm specifies a two-digit integer (for example, 35) that identifies the minutes after the metric hour in which the Cisco IP Telephony produced the CSV file.

•SerialNumber specifies the serial number of the file, in case there are multiple files for a single period.

Example: cdrcmr_cluster_01_201005150835_10001.csv

Bulk input file schema

For Cisco CallManager version 4.x, CDR data is stored in a Microsoft SQL Server 2000 database. The Cisco IP Telephony Technology Pack connects directly to the database and uses an SQL query to retrieve the data. Perfmon is not supported for Cisco CallManager version 4.x.

For Cisco Unified Communications Manager versions 5.x and higher, the ProvisoCUCM Java application uses the AXL/SOAP API delivered by the device to collect both CDR and Perfmon data. For CDR, a SOAP query to the CUCM server requests all CDR data for a certain time period. The CUCM server uses FTP to send the data back to a specified host. The data is delivered in two formats, CDR and CMR, which are concatenated to produce a CSV format for the UBA. Perfmon data is delivered in-band as a response to the SOAP request, and is also written into a CSV format for the UBA.

Example CDR CSV file:

1,1,6177065,5362499,1273883641,1,0,760260612,"6076","termine",0,1,4,0,0,57,0,0,0

,0,0,0,0,"0","0",19835742,0,0,0,"6096","6096","",0,0,4,0,0,0,0,0,0,0,0,0,0,"0"," 0",0,1273883673,"6001","593fa05e-bc1d-4dc5-9cca- 6c25184e7e98","","Phones","","",69,"SEP00155832DDD1","",13,0,0,0,0,0,0,"StandAlo

10 IBM Tivoli Netcool/Proviso Cisco IP Telephony 2.4.0.0 Technology Pack