Grandstream UCM6300 Series IP PBX CDR Tool Guide

Grandstream Networks, Inc.

Copyright and Warranty Information

All rights reserved. Information in this document is subject to change without notice. Reproduction or transmittal of the entire or any part, in any form or by any means, electronic or print, for any purpose without the express written permission of Grandstream Networks, Inc. is not permitted.

The latest electronic version of this guide is available for download here: www.grandstream.com/support

Grandstream is a registered trademark and Grandstream logo is trademark of Grandstream Networks, Inc. in the United States, Europe, and other countries.

CAUTION: Changes or modifications to this product not expressly approved by Grandstream, or operation of this product in any way other than as detailed by this guide, could void your manufacturer warranty.

Change Log

This section documents significant changes from previous versions of CDR Tool Guide. Only major new features or major document updates are listed here. Minor updates for corrections or editing are not documented here.

Version 1.0.0.2

This is the initial version.

Welcome

Overview

CDR Assistant Tool is an assistant tool developed based on UCM platform with trend network UCM630x series. The tool provides users with convenient and fast CDR backup data analysis, query and filtering operations, so as to prevent users from inconvenient use of CDR data packets, which causes difficulty in data search, CSV file format affects reading, and easy data loss. Users only need to download the CDR View Assistant tool to import and query CDR data, which greatly improves the work efficiency of operation and maintain its easy management.

Feature Highlights

The software can be used without logging in/registering.
Support parsing CDR data.
Support decrypting recording files.
Support CDR data retention on the tool side and can still be viewed next time if it is opened.
Support simultaneous import of multiple CDR backup files of the same UCM device. The number of files is not limited.
The software interface text supports Chinese and English.

Technical Specifications

Features	Description
Encryption and Decryption algorithm	AES-256
Audio Encoding	WAV
Multi-language support	Support English and Chinese Simplified.
Login Method	No sign-in required
Download/Upgrade	Grandstream official website

Please visit our website for more information and product documentations: www.grandstream.com

Installation of the Tool

After downloading the installation program, the user can double-click to open the program and understand the copyright statement. Click on the "Accept" button to proceed to the next step.

Figure 1: CDR Assistant Tool installation interface

Click "Browse" to select the tool installation path, and when you are done, click "Extract". Once the operation is complete, the CDR Assistant tool is installed under that chosen directory.

Figure 2: CDR assistant tool extraction interface

After opening the folder, you can see the cdrtool file, open the cdrtools.exe application under that folder. Wait a few seconds to enter the CDR View Assistant interface.

Figure 3: CDR Assistant Tool interface

File Import/Export

File Import

Click on "Import File" under "File" in the upper left corner of the interface to select the CDR file (.cenc) that needs to be parsed backed up by the GDMS server.

Must upload .cenc format file.
In the case of file encryption, the user needs to enter the file password for verification. After the password is correct, the file will be parsed and uploaded to the CDR list.
The file password is the initial password of the UCM device, which can be viewed on the LCD screen of the device.
The tool supports simultaneous import of multiple CDR backup files of the same UCM device.

Note: If the password is entered incorrectly for more than three times, it will prompt that the database has failed to load. The user must upload the file again and enter the correct password.

File Export

There are two ways to export CDR backup package files:

Click "Export to CSV" under "File" at the top left corner of the interface to export all data.
Click "Export Search Results" in the lower left corner of the interface and export the required data according to the filter results.

The exported file formats are all CSV.

File Filtering

Users can select specified conditions in the filters mentioned above the CDR list to obtain the target CDR data they are looking for.

Figure 4: Filter Options

Filter	Description
Start time	Specify the start time to filter the CDR report. Click on the arrow on the right and the calendar will show for users to select the exact date and time.
End time	Specify the end time to filter the CDR report. Click on the arrow on the right and the calendar will show for users to select the exact date and time.
Caller Number	Enter the caller number to filter the CDR report. CDR with the matching caller number will be filtered out. User could specify a particular caller number or enter a pattern. '.' matches zero or more characters, only appears in the end. 'X' matches any digit from 0 to 9, case-insensitive, repeatable, only appears in the end. For example: 3XXX: It will filter out CDR that having caller number with leading digit 3 and of 4 digits' length. 3.: It will filter out CDR that having caller number with leading digit 3 and of any length.
Caller Name	Enter the caller name to filter the CDR report. CDR with the matching caller name will be filtered out. Note: Numbers, letters, special characters, and special symbols are not allowed.
Callee Number	Enter the Callee number to filter the CDR report. CDR with the matching Callee number will be filtered out.
Account Code	Select the account Code to filter with. If pin group CDR is enabled, the call with pin group information will be displayed as part of the CDR under Account Code Field.
Source Trunk Name	Select source trunk(s) and the CDR of calls going through inbound the trunk(s) will be filtered out.
Destination Trunk Name	Select destination trunk(s) and the CDR of calls going outbound through the trunk(s) will be filtered out.
Action Type	Filter calls using the Action Type, the following actions are available: Announcement, Announcement Paging, Announcement Center, Call Return, Call Forward, Audio Conference, Basic Call, DISA, Emergency Calls, Emergency Notify, Fax, Follow me, IVR, Paging/Intercom, Parking Lot, Presence Status, Queues, Ring Group, SCA, Transfer,VFAX, Video Conference, Voicemail, Voicemail Groups, Virtual Queue CallBack, Wakeup Service.
Extension Group	Specify the Extension Group name to filter with.
Call Type	Groups the following: Inbound calls: Inbound calls are calls originated from a non-internal source (like a VoIP trunk) and sent to an internal extension. Outbound calls: Outbound calls are calls sent to a non-internal source (like a VoIP trunk) from an internal extension. Internal calls: Internal calls are calls from one internal extension to another extension, which are not sent over a trunk. External calls: External calls are calls sent from one trunk to another trunk, which are not sent to any internal extension
Status	Filter with the call status, the available statuses are the following: Answered No Answer Busy Failed

Decrypt Recording Files

To decrypt the recording file, the user can click on "File" in the upper left corner of the interface, and click "Record Decrypt" to add the recording backup .venc file to be analyzed, as shown in the figure below.

Files in .venc format must be uploaded, and files in other formats do not need to be decrypted.
After adding files, choose to export to a local directory. Click "Start Decryption" to decrypt the recording file. The decrypted file will be saved in the specified directory in WAV format.
The file password is the default password of the UCM device, which can be viewed on the LCD screen of the device.

Figure 5: Recording Decryption

Note: If the password is entered incorrectly for more than three times, it will prompt that the decryption of the recording file has failed. The user must upload the file again and enter the correct password.

Set-up

File Menu Operations

By Clicking on the "File" button in the upper left corner of the tool, users get to perform some important operations related to the CDR tool including: Import file, Export to CSV File, Clear Database, Decrypt recordings and exit.

Figure 6: File Menu

Features	Description
Import File	Import CDR backup package files.
Export to CSV File	Export all data from the CDR list to generate a CSV file.
Clear Database	This will empty all current data. Without clearing the database, CDR list data under the same UCM device is continuously superimposed, affecting usage.
Record Decrypt	Add a recording file and the WAV file will be generated when the operation is complete.
Exit	Exit the CDR assistant tool.

Language Support

The CDR Assistant tool currently supports only Chinese and English.

Figure 7: Language Menu

Help

About CDR Tools

This computer program is protected by copyright law and international treaties. Unauthorized reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under the law.

FAQ

The link jumps to the user manual interface of the software to browse the contents of this user manual.

Figure 8: Help Menu

	Grandstream UCM6300/A Series IP PBX CDR Tool Guide Comprehensive guide to Grandstream's CDR Assistant Tool for UCM6300/A Series IP PBX, detailing features for analyzing, querying, filtering, and decrypting call detail records and recordings.
	Grandstream UCM6xxx Series IP PBX: Lightweight Call Center Guide A comprehensive guide to setting up and managing call centers using Grandstream's UCM6xxx Series IP PBX. Covers features like call queues, agent management, CTI, CRM integration, and typical configurations for SMBs.
	Grandstream GAC2570 Quick User Guide A concise guide to using the Grandstream GAC2570 Audio Conference Phone for Android, covering call functions, conference features, and connectivity.
	Grandstream Wave Web Administration Guide A comprehensive guide to administering and configuring the Grandstream Wave Web client, a WebRTC-based application for UCM63xx/Audio series IP PBX systems, enabling users to participate in audio and video conferences, manage calls, and utilize unified communications features.
	Grandstream UCM6xxx Series IVR Configuration Guide A comprehensive guide to configuring Interactive Voice Response (IVR) systems on Grandstream UCM6xxx series IP PBX devices, covering basic setup, custom prompts, key pressing events, and application examples for different scenarios.
	Grandstream UCM6300 Series RemoteConnect User Guide User guide for Grandstream UCM6300 Series IP PBX, detailing the setup and usage of the UCM RemoteConnect service for remote communication, collaboration, and management via GDMS and GS Wave applications.
	Grandstream UCM6300 Series UC & Collaboration Solutions Explore the Grandstream UCM6300 Series, a comprehensive UC and Collaboration Solution designed to mobilize your business. Discover features like seamless remote extensions, cloud-based management via GDMS, and the Wave app for anywhere connectivity. This document details various models including UCM6300A, UCM6302A, UCM6304A, UCM6308A, UCM6301, UCM6302, UCM6304, and UCM6308, outlining their specifications, capabilities, and ideal deployment scenarios for businesses of all sizes.
	Grandstream Specialist Certification: VoIP and UC Essentials Explore the Grandstream Specialist Certification program, covering VoIP fundamentals, UC portfolio, installation, call management, and CU features. Learn about API integration, security, failover, and management platforms.