Chapter 2: Devices and Services
10 IBM Tivoli Netcool/Proviso Cisco IP Telephony 2.4.0.0 Technology Pack
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