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.