“Report management” module is located in the “Users and statistics” menu. This module allows to manage and configure “Statistics” and “Counters” services, and also allows to configure reports of these services (default or custom forms). This module contains tabs: “Reports management”, “Reports designer”, “Services”, “Settings”, “Log”.
“Reports management” tab is divided into two windows. In the first window you can see list of all reports - preset by the system and custom made by ICS CUBE Administrator. In the second window, contents of report selected in the first window is displayed. Default reports cannot be edited or deleted. To add a new report press “Add” button (tab “Report designer” will be opened), to delete - “Delete” button, to edit - “Edit” button (the report will be opened in “Report designer” tab with the fields filled with appropriate for this report values).
Also on this tab you can find time period for the information shown in the report (01.11.19 will be used as an example of the current date): “Today” (report for 01.11.19 will be shown), “Week” (report for the period 28.10.19-03.11.19 will be shown), “Month” (report for the period 01.11.19-30.11.19 will be shown), “Period” (you need to specify the period for which report will be shown).
You can use the “Export” button to export report into one of the following formats: *.csv, *.txt, *.xls. Please, note, that pie charts will be exported as tables.
“Reports designer” tab allows to create reports using filter parameters that can be applied to general statistics in any combination to show required statistical data. The main “Reports designer” window is divided into two. The first window is for parameters of filter settings, as can be seen in the table:
|Name||This field is enabled when you edit previously created report. Allows to change the report’s name.|
|View||Allows to set one of the four possible types of view: “HTTP details”, “IP details”, “Grid”, “Pie”, “Bars”, “Bubbles”. “HTTP details” will show a table with HTTP/HTTPS traffic statistics, gathered from proxy-server. “IP details” will show a table with statistics for all the connections that went through ICS CUBE, by IP-address. “Gird” will show chosen data as a table. “Pie” will show chosen data as a pie chart.|
|Grouping||This function groups all the shown data by principle chosen in the second window. Grouping can be: by destination, by source, by interface, by ip-addresses and domains, by protocols, by ports, by mime-types, by timestamp. Also you can set more detailed grouping for each display area. If the report view is organized in table form, you can group them using multiple criteria. Grouping will be performed as follows: the first level of a tree will be grouped by the first value of the field, second level by second value etc. Grouping is the only one mandatory parameter in report creation.|
|Source||Allows to filter grouped statistics by source. You can set an address range or an IP-address that configured in ICS CUBE in this field.|
|Destination||Allows to filter grouped statistics by destination. You can set an address range or an IP-address that is configured in ICS CUBE, in this field.|
|Interface||Allows to filter grouped statistics by interface, that is configured in the ICS CUBE. You can choose tunnels, DMZ, VPN, external and internal interfaces in this field.|
|IP or domain||Allows to filter grouped statistics by IP-address or domain.|
|Protocol/port||First field allows to filter grouped statistics by one of the protocols (IP, ICMP, TCP, UDP, GRE, IPIP, L2TP). Second field allows to filter grouped statistics by port: ICS CUBE service port, well-known port or any other.|
|MIME type||Allows to filter grouped statistics by one of the pre-set mime-types.|
|Result||Allows to filter grouped statistics by reply code from external web-server.|
|Time (from … to)||Allows to filter grouped statistics to match only a certain time period, in hours.|
After all the necessary filters are chosen and “Show” button is pressed, you will be able to see the report in the second window. If it is a table report, you will be able to show and hide columns, manage the order and format of the data, like it happens in other tables in ICS CUBE interface. To save the chosen filter combination and use it in future without setting it up again, you need to press “Save the report” button. ICS CUBE will suggest to choose report category (“Statistics report” or “User report”), then to enter the report’s name and then will save it among other standard reports. Created report will be available in “Reports management” tab.
Data, filtered from detailed statistics in the report, can be exported into a file (.csv, .txt, .xls), and thus become available for printing. When one of the formats is chosen, a new “Settings” window will be opened where you can set export parameters (“Export all the pages”, “Export as a tree” with an opportunity to choose the level of details in the tree). Also in this tab you can choose time period for the report (in this example the current date will be 30.07.18): “Today” (report for the 30.07.18), “Week” (report for the 30.08.18-05.08.18), “Month” (report for the 01.07.18-31.07.18), “Other period” (you will need to choose the period). It should be noted that pie charts will be transformed into tables for export.
“Services” tab displays statuses of the services “Statistics” and “Counters” - enabled or disabled. Also on this tab you can find event log for the current date.
“Settings” tab allows to set parameters for siewing and storing of the logs of these services.
In “Users for which don't show URL” field you can set users or/and groups of users for which the URLs of the visited pages won’t be shown in reports. In the report you will see “hidden.url” in such case for all the URLs. It should be noted that this setting will be applied only to newly gathered statistics.
If “Firewall blocks logging” is set, then in a report you will see what was blocked by the firewall. To view this, in “Reports designer” tab choose: in the “view” field - “IP details”, in the “result” field - “403 Forbidden”.
If “Reports by traffic categories” checkbox is ticked, then for reports of “HTTP details” type there will be a category for each URL.
“Delete automatically” block allows to set time period or quota for storing the statistics and detailed statistics. Also those parameters can be set in Maintenance - System - Data deletion.
“Log” tab shows all the system messages of the module with a timestamp. Log is divided into pages, you can navigate through them using “Next” and “Previous” buttons, or enter the required page number in appropriate field.
Log messages are marked by color depending on their type. Normal system messages are white, system status messages (enabling/disabling, user connection) are green, warnings are yellow and errors are red.
In the top right corner of the module there is a search line. Also there is an opportunity to choose the period for which the log will be shown. By default log is showing events for the current date.
If needed, the log can be saved into a file by using “Export” button, and deleted for a period with “Delete logs” button.