JeraSoft Documentation Portal
Docs for all releases
This section allows you to form a detailed calls statistics on each client with a description of every call parameter. Here you can create a report based on an existing template or generate a new one. The main window represents a query form similar to those of other reports:
Screenshot: CDRs List query form
In order to create a new CDR list go to the Statistics section and open the CDRs List. Then you need to fill out the search form with next parameters:
On the Filters menu, select convenient parameters for the report. To cancel any filter, click the delete sign next to the filter.
Specify an interval for the report. This field is mandatory.
There are following accessible additional filters:
|Client Type||Select a client's type for report (Client, Reseller, Calling card or Call shop)|
|Client||Define a client for the report|
|Account||Enter an account for the report|
|Tags||Define a client's tag|
|Cards Serial||Indicate cards serial for the report|
|Package||Enter a package for the report|
|Code||Specify a code of needed destination|
|Code Name||Specify a code name of the desired destination|
|Cost||Enter the range of call cost|
|Call Origin||Indicate call origination/termination|
Choose a call processing state:
|Disconnect Code||Define a disconnect code as a filtering parameter|
|VoIP Gateway||Specify a VoIP host as filtering criteria|
|Owner||Indicate the owner|
|Time Total||Enter the range of total calls duration in minutes|
|Rate||Indicate the destination rate of the call|
|Additive Rate||Specify extra destination rate (per 1 minute) that was used.|
|DST Number||Billed destination number|
|SRC Number||Billed source number|
Conference ID value.
|CDR ID||CDR ID value|
|Session Time||Call duration|
Specify call processing state:
Choose a respective state:
Choose a respective state:
|Currency||Indicate a respective currency|
This form contains settings of the output data of the report.
Click plus sign near the "Columns" and select columns to output a report data. Also, you can cancel any chosen item.
|Accessible columns in the report|
There are following columns to add to the report:
|Other output settings|
Select parameters to sort already grouped data in columns. Here you can sort data from highest to lowest values (or vice versa) and select different values.
Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx. The "Plain" type of view is by default.
You can send generated reports via e-mail.
For example, it is useful when it takes a lot of time to run the report. Also, it is possible to specify several e-mails.
This feature is available only for CSV/Excel XLS/Excel XLSx formats of the report, it doesn't work with Web.
Specify a currency for the report. And all values will be automatically converted in the report to the specified currency.
Select a code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck.
After selecting all needed parameters, click “Query” button and the system will generate a report:
Screenshot: CDRs List report window
Also, you can create a template for reports and save specified parameters by clicking "Save Query" button. A pop-up window with settings will appear and you need to fill out the following form:
Screenshot: New Query Template form
|CDRs List||Here you can specify parameters for the template that will be used while running reports|
|Title||Specify a name of the template|
|Reseller||Indicate a Reseller for the report template|
This tool allows to generate reports at the appropriate time and send results to the list of e-mails.
|Recipients||Specify recipients, you can indicate your own e-mail or other users of the system, or even 3rd parties|
|Run Time||Mention an appropriate time to automatically generate a report, it could be several times, for example: "10:00, 12:00, 18:00"|
|Days of Week||Mention days of the week to automatically generate a report. For example, you can run a report only on Monday or each day of week|
Here you need to specify filters that will be used for generating correct report and choose the output type to view the report
Screenshot: CDRs List form
How to perform a search by partial Conf ID:
For example, the Conf ID of a respective call is 1647398901830024226688. To filter calls by: