This documentation relates to an earlier version of JeraSoft VCS.
View User Guide 3.24 or visit our current documentation home page.
In this article

Section overview

This section allows you forming detailed statistics on each client with a description of each event. Here you can create a report, based on an existing template or generate a new one. The section consists of a query form similar to those of other reports: 

Screenshot: xDRs List query form

Creating an xDR Report

To create a new report, you need to fill in the following parameters in the form and click the Query button:

Information BlockField Description
Filters

On the Filters menu, select the required parameters for the report. To cancel any filter, click on the delete  icon next to the filter.

You can start a quick search by typing filters' names in the field at the top of a drop-down menu with filters.

Period

Specify the time interval for the report and a timezone. Please note that the Period field is mandatory.

Additional Filters

There are the following accessible additional filters:

  • Clients: Client Type, Client, Client Tags, Account Tags, Cards Serial, Account, Package.
  • Events: Dst Code, Dst Code Name, Origin, Result Code, Tags, Gateway.
  • Extras: Service, Owner, Src Code, Src Code Name, Result Status, Rate, Setup Fee, DST Party ID, SRC Party ID, Session ID, XDR ID, Volume, Cost, Status, Match Clients, Match Codes, Currency.
Client TypeSelect a client's type for the report (Client, Reseller, Calling Card or Call Shop)
Client Define a client for the report
Client TagsSpecify customer's tags
AccountEnter a client's account for the report
Account TagsDetermine account's tags
Cards Serial Indicate cards serial for the report
PackageEnter a package name for the report (can be active or archived Package)
CodeSpecify a code of a target destination
Code NameSpecify a code name of a target destination
Origin

Indicate event origin

Result CodeDetermine a disconnect code as a filtering parameter
TagsIndicate tags for the report
GatewaySpecify a host as a filtering criterion
Service NameSelect a type of service (data, call, SMS) for the report
OwnerIndicate a reseller
Src CodeSpecify a code of a source number
Src Code NameSpecify a code name of a source number
Result Status

Choose a disconnect processing state:

  • Success (code = 16 or 31)
  • Busy (code = 17)
  • No channel (code = 34)
  • Error
RateIndicate the destination rate
Setup FeeSpecify a setup fee of an event
DST Party IDDetermine the DST Party ID (destination number or any other identification of destination) that is used for detection of destination and billing (after all translations)
SRC Party IDDetermine the SRC Party ID (source number or any other source identification)
Session IDID of the session received from the gateway
xDR IDxDR ID value
VolumeVolume of the service (e.g., call duration)
Cost Enter the range of event cost
Status

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 report output data.

Click the plus  icon next to Columns and select the required columns to add them to the Output information block. Also, you can cancel any chosen item.

Accessible columns in the report

There are the following columns to add to the report:

  • Clients: Client Type, Clients Tags, Client ID, Client, Account, Account ID, Accounts Tags, CC Series, Owner, Owner ID, Package ID, Package Name.
  • Events: Code, Code Name, Country Name, Currency, Rate, Setup fee, Origin, Result Status, Result Code, Gateway ID, Gateway.
  • Extras: Event time, Client Tags, Accounts Tags, Tags, Volume, Billed Volume, Package Volume, Package Credit, Cost, Taxes, Subscriber IP, Subscriber Name, Switch Code, Start Time, Connect Time, Finish Time, PDD, SCD, Session ID, x ID, Src Party ID, Dst Party ID, SCR Party ID EXT, DST Party ID EXT, SCR Party ID BILL,DST Party ID BILL, xDR Source, xDR ID, Uniq Sign, Custom, Extra Data, Status, Service Name, Unit.
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 set by default.

Send to

You can send generated reports via email. Also, it is possible to specify several emails.

(warning)   Attention

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. All values will be automatically converted to the specified currency in the report.

Dst Code Deck

Select a destination code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck.

Src Code DeckSelect a source code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck.

Below you will find an example of a generated xDRs report:

Screenshot: xDRs report

Also, you can create a template for reports and save specified parameters by clicking the Save Query button. Visit our Report Queries article for detailed information.  

xDR Report export buttons

You can export data to a CSV or XLSx file, which contains only currently displayed data, with no automatic request to update data while exporting

  1. To download a report in .csv, click on the Export to CSV button above the report.
  2. To download a .xlsx report file, click on the Export to XLSx  button above the report.

Search by partial Session ID

How to perform a search by partial Session ID:

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

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

Knowledge Base Articles

  • No labels