IBM Sametime 9 introduces high quality video allowing administrators to enable a hassle free Real Time Communication service. With improved bandwidth management and the latest Scalable Video Coding (SVC) capability for H264 Video, Sametime 9 enables enterprises to provide large scale deployment within the organization and externally, thus making video a highly used and consumed service. As the video usage increases, it brings a requirement for administrators to provide auditing and call records for the usage of video service by users.
Retrieving CDR Data
Automate Report Generation
Use the script fetchCDRReports.sh for automating the report generation.
Schedule the fetchCDRReports.sh
script as a cron job to run on daily basis. The fetchCDRReports.sh
script fetches the report from the Video Manager and stores it to the directory specified as input.
This example generates a file as output CDR_MM-DD-YY.zip. Schedule the script as a cron job that runs near midnight, for example at approximately 23.58 – 23.59.
If you have a Video Manager cluster, schedule the script to run on each of the Video Manager nodes in the cluster.
Fetch CDR information using REST API
To retrieve the following CDR information, use the REST API.
Retrieves a list of CDRs matching the input search filter parameters. The API returns a zip file with three files inside one zipped file, which is streamed to the user. The three files will separately list calls, conference as CSV and call,conference counts as txt file.
The GET method's default search returns all CDRs from midnight of the current day to the current time when search criteria is not provided.
: Datetime format is [-]CCYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm]. Examples include: 2001-10-26T21:32:52, 2001-10-26T21:32:52+02:00, 2001-10-26T19:32:52Z, 2001-10-26T19:32:52+00:00, -2001-10-26T21:32:52, or 2001-10-26T21:32:52.12679
Use CDR to audit all of the details of a conference. Unzip the download file to obtain all of the conference details provided in these two files:
Use Microsoft Excel or another spreadsheet application to open these CSV files. The CSV files contain a line for each call or conference during the selected time frame.
The ZIP file also includes a text file that contains a single line specifying:
The number of calls in the call CDR file.
The number conferences in the conference CDR file.
Call and conference counts in txt file
To retrieve CDR information from the Video Manager cluster, use the rest API on each individual Video Manager node and collect the zip files.
Sample CDR Analysis
Call Data Records(CDR) contain all of the detail information about an audio video conference.
Alice starts an audio video call on Sametime 9. This call is then joined by Bob and Peter.
file provides the details about the conference while call.csv
file provides the details of all the participants who joined this conference. The mapping between the two csv files is done using Conf-uuid.
A detailed description of each field in the both of these csv files is presented in this doc
The following table contains fields from the conference.csv
for the conference.
The call.csv file contains the participant details for the same conference. The refConfUUID
field in call.csv can be mapped with confUUID value to get details of all the participants in this conference. In this example, we see three entries for this confUUID becasure there are three participants in the call.
The following table contains fields from the call.csv
file for all participants who joined the conference.