Versions Compared

Old Version 5

changes.mady.by.user Anastasiia Kovalinas

Saved on

compared with

New Version 6

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This section allows you to view, execute and manage the Report Queries of Active Sessions, Balance Report, Customer Dynamics, Invoicing Report, LCR Lists, Orig-Term Report, Profit Report, Rates Analysis, Routing Analysis, Summary Report, and xDRs List. Moreover, you can send reports to by email to keep yourself informed about the traffic status without the need to log in to the system and query reports. The section structure is as follows:

Screenshot: Report Queries section main window

Image RemovedImage Added

ColumnDescription
IDQuery ID
NameName of the query
QueryQuery details
To EmailTool to run a report automatically at the exact time and send the results to the list of emails
MonitoringTool to be used for Traffic Processing and/or notifications per the given schedule

The section contains the following functional icons:

IconDescription

Allows creating a new report query

Allows previewing a query

 

Allows running a respective report by this query

Indicates thatsending a report via email option/monitoring option is enabled.

Info

You can enable/disable the to email  the rule after it's been created in the system by clicking the indication icon.


Indicates thatsending a report via email/monitoring option is disabled.

To start managing, choose the respective query from the section and click on the name to open the settings.

...

You can create a report query either using a New Report Query button in the main section , or from the respective sections while generating reports. If you are adding a new query from the report section, you need to: 

...

Panel
borderColor#FFBABA
bgColor#FFBABA
borderWidth2px
borderStylesolid

Warning

If you create the report query and the To Email option is enabled, the client will receive the file with a report even when there are no statistics for a specified period.

Monitoring Tab

After creating the Query, you can manage whether to allow generating reports at the specific times and send results to specified emails. For this, open the needed Report Query, and click the To Email tab:

Screenshot: Monitoring tab

Image Added

Information BlockDescription
GeneralStatus

Specify if this function is on:

  • Enabled
  • Disabled
Output Type

Specify a file type to be sent:

  • CSV
  • Excel
RecipientsUsersDefine system Users to send a Query to (can be empty if the Extra Emails field is filled in)
Extra EmailsSpecify the needed extra email addresses (can be empty if the Users field is filled in)
SchedulingType

Report generation scheduling approach:

  • fixed (run at specific times/days);
  • periodic (run at certain intervals).
Fixed

TimezoneIndicate a timezone for a selected report run time
Add Time button
  • Time - specify the time;
  • Days of the Week - specify the needed frequency (Daily, Weekdays, Weekends, Custom);
  • Specific days - becomes active if Custom is selected as a Days of the Week parameter. Specify exact days here.
Tip
titleTip

If you want to receive reports for a previous month every 1st day of the next month, you will need to:

  • set Last Month as an Interval in the Query
  • set First Run in the To Email as the first day of the month

The report will be queried for the previous interval and be sent to the respective email/-s on the first day of each month.


Last RunIndicates when the report was last run by the system
Periodic



Every

Determine an appropriate interval to generate a report automatically, it could be in minutes, hours, days, weeks, or years.

First RunOffset a specific date & time up to a second (incl. a timezone) for the first run of a report
Last RunIndicates when the report was last run by the system