Docs for all releases
Page History
...
If the data is grouped in the report, it will be shown initially collapsed. To expand or collapse data in your report, click the 
plus or 
minus signsicons.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Please note, this function requires RADIUS Accounting Start packets to be sent from your Gateway and and the Track Active Events option enabled in the Gateways section. Be advised that the Track Active Events option diminishes system performance. Please, activate activate it only if you use capacity control by billing and/or require active sessions status monitoring. |
Creating an active sessions report
In order to To create a report, fill in the query form with the parameters , specified below, and press Query click the Query button. A screenshot of a generated report is presented above.
| Information blockBlock | Field Description | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Filters | On the Filters menu, select required parameters for the report. To cancel any filter, click on the delete You can start a quick search by typing filters' names in the field at the top of a drop-down menu with filters. | |||||||||
| Group Byby | Select a grouping option, here . Here you can choose and swap columns, or change their order. There are the following accessible options to group the data in the report:
| |||||||||
Additional Filters | ||||||||||
There are the following accessible additional filters:
| ||||||||||
| Orig Client | Define an origination client for the report | |||||||||
| Orig Account | Enter an orig origination account for the report | |||||||||
| Orig Code | Specify an orig origination code for the report | |||||||||
| Orig Code Name | Indicate an orig origination code name | |||||||||
| Term Client | Define a termination client for the report | |||||||||
| Term Account | Enter a term termination account for the report | |||||||||
| Term Code | Specify a term termination code for the report | |||||||||
| Term Code Name | Indicate a term termination code name | |||||||||
| Output | This form contains settings of the report output data. Click the plus | |||||||||
| Accessible columns in the report | ||||||||||
There are the following columns to add in the report:
| ||||||||||
Total | Quantity Total quantity of sessions in the database, total quantity. | |||||||||
| Info | By hovering over the Info
Screenshot: Info
| |||||||||
| Originator | The name of the originator, orig gateway, account IP, Name or ANI. | |||||||||
| Terminator | The name of the terminator, term gateway, account IP, Name or ANI. | |||||||||
| Src Party ID | The source number. | |||||||||
| Dst Party ID | The destination number. | |||||||||
| Duration | Session duration, specified in seconds. | |||||||||
| Other output settings | ||||||||||
| Order Byby | 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 Also, select next to the Type field a look of table view:
| |||||||||
| Limit | Determine the number of rows that will be visible in the report. It is useful for displaying some top positions by a chosen parameter. It is available only for for the Plain type of the report. | |||||||||
| Send to | You can send generated reports via email. Also, it is possible to specify several emails.
| |||||||||
Query templates
Also, you can create a template for reports and save specified parameters by clicking the Save Query button in the form. A pop-up window with settings will appear, and you will need to fill in the form. Detailed description on creating a template can be find found in the Report Templates article in our User Guide.
To load already existing templates while generating statistic reports, press click the Load Query button and click on the 
icon opposite a target template on the list.
...
You can export data to a CSV and or XLSx file, which contains only currently displayed data, with no automatic request to update data while exporting. Also, it is possible to create charts for easily illustrating a crucial informationfor illustrating crucial information easily. And you can generate a report using the same criteria in the Orig-Term reportReport and the xDRs listList sections.
1. To set a reload interval of the report, press click the respective Reload options button and choose a select needed values in the Interval and and Show last fieldsLast fields.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
 TipThe Show last Last field defines the period, for which data is generated in a report. For example, if you want to display the data for 1 day, in specify it in the Show last field specify. |
2. To download a report in .csv, click on the Export to CSV
button above the report.
...
3. To download an .xlsx report file, press click the Export to XLSx 
button above the report.
...
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Tip If you want to create a proper Line chart for different clients, please follow these steps:
|
...
Overview
Content Tools