This documentation relates to an earlier version of JeraSoft VCS.
View User Guide 3.19 or visit our current documentation home page.
Skip to end of metadata
Go to start of metadata
On this page

CDRs List Query Form

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

To create CDR report

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:

SectionField Description
Filters

On the Filters menu, select convenient parameters for the report. To cancel any filter, click the delete sign next to the filter.
You can start a quick search by typing filters' names in the bar at the top of drop-down menu with filters.

Period

Specify an interval for the report. This field is mandatory.

Additional Filters

There are following accessible additional filters:
 

  • By clients: Client Type, Client, Account, Tags, Cards Serial, Package.
  • By calls: Code, Code Name, Cost, Call Origin, Result Status, Disconnect Code, VoIP Gateway.
  • Extras: Owner, Rate, Additive Rate, DST Number, SRC Number, Conf ID, CDR ID, Session Time, Status, Match Clients, Match Codes, Currency.
 
Client TypeSelect a client's type for report (Client, Reseller, Calling card or Call shop)
Client Define a client for the report
AccountEnter an account for the report
Tags Define a client's tag
Cards Serial Indicate cards serial for the report
PackageEnter a package for the report
CodeSpecify a code of needed destination
Code NameSpecify a code name of the desired destination
Cost Enter the range of call cost
Call OriginIndicate call origination/termination
Result Status

Choose a call processing state:

  • Success
  • Busy
  • No channel
  • Error
Disconnect CodeDefine a disconnect code as a filtering parameter
VoIP GatewaySpecify a VoIP host as filtering criteria
OwnerIndicate the owner
Time Total Enter the range of total calls duration in minutes
RateIndicate the destination rate of the call
Additive RateSpecify extra destination rate (per 1 minute) that was used.
DST NumberBilled destination number
SRC NumberBilled source number
Conf ID

Conference ID value.
You can filter calls by partial Conf ID in the CDRs list section. To perform a partial search,
please use an asterisk (* ) in the "Conf ID" field of the filters sub-panel. 

CDR IDCDR ID value
Session TimeCall duration
Status

Specify call processing state:

  • all
  • processed
  • in rerating
Match Clients

Choose a respective state:

  • matched clients (identified),
  • mismatched clients (not identified).
Match Codes

Choose a respective state:

  • matched codes,
  • mismatched codes. 
CurrencyIndicate a respective currency
Output



This form contains settings of the output data of the report.

Click plus sign  near the "Columnsand 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:

  • By clients: Account, Account ID, Client Type, Client ID, Client, CC Series, Owner, Owner ID, Package ID.
  • By calls: Code Country, Code, Code Name, Rate, VoIP Gateway, Currency, Additive Rate, Call Origin, Result Status, Disconnect Code, VoIP Gateway ID, Setup Fee.
  • Extras: Call Time,Gateway IP, Gateway Name, SRC Number, DST Number, Billed Time,Package Time, Package Credit, Cost, Cost Total, Rate Total, Session Time, Tags, Package Name, Cost Extra, Taxes Value, Switch Code, Setup Time, Connect Time, Disconnect Time, PDD,SCD,Conf ID, Call ID, SRC Number EXT, DST Number EXT,SRC Number BILL,DST Number BILL, CDR Source, CDR ID, Uniq Sign, Bytes IN, Bytes OUT, Custom,Extra Data, Status.
Other output settings
Order By

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.

Type

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.

Send to

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.

Currency

Specify a currency for the report. And all values will be automatically converted in the report to the specified currency.

Code Deck

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

To create query template

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


 

SectionDescription
CDRs ListHere you can specify parameters for the template that will be used while running reports
TitleSpecify a name of the template
ResellerIndicate a Reseller for the report template
Watch

This tool allows to generate reports at the appropriate time and send results to the list of e-mails.
Please note, that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx.

RecipientsSpecify recipients, you can indicate your own e-mail or other users of the system, or even 3rd parties
Run TimeMention an appropriate time to automatically generate a report, it could be several times, for example: "10:00, 12:00, 18:00"
Days of WeekMention days of the week to automatically generate a report. For example, you can run a report only on Monday or each day of week
Report Query

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


 

  1. To load already existed templates while generating statistic reports click "Load Query" button in the CDRs List section
  2. You can export data in CSV or XLSx file that contains only currently presented data, no automatic request to update data while exporting.
    • To download a .csv fileclick the "Export to CSV"  button on the toolbar. 
    • To download a .xlsx fileclick the "Export to XLSx"  button on the toolbar. 

Search by partial Conf ID

How to perform a search by partial Conf ID:

For example, the Conf ID of a respective call is 1647398901830024226688. To filter calls by:

  • To filter calls by the first digits of Conf ID, enter digits + asterisk(*): 16*. 
  • To search calls by the middle digits of Conf ID, enter a search term by this formula: asterisk(*) + digits + asterisk(*): *7398*. It will match any Conf ID containing the string 7398, even if it occurs in the middle of a large number.
  • To find calls by the last digits of Conf ID, enter asterisk(*) + digits: *88.  

Screenshot: CDRs List section

Knowledge Base Articles

  • No labels