User Tools

Site Tools


howto:create-a-report

Create a report

There are two types of reports:

  • Graphical reports
  • Reports

Graphical reports

Graphical reports are based on live data, ie. the current state.

Active users history

[ day, week, month, year ] This report allows you to get insight into the number of active subscribers. Use the checkboxes at the top of the graph to hide or display subscribers based on their status: active, idle or pending.

Bandwidth report

[ day, week, month, year ] Bandwidth reports are per interface and provide an overview of download and upload over that interface from the HSMX perspective (upload egresses the HSMX, download is inbound traffic towards the HSMX). The data is in kilobyte per seconds.

Connections history

[ day, week, month, year ] The number of OSI layer 3 connections (TCP) going through the HSMX towards the internet. Can give a good indication of the amount of subscribers or whether network abusive protocols such as Bittorrent are in use (these protocols tend to open a lot of connections).

CPU history

[ day, week ] An overview of the CPU load aggregrated per minute. Use this data to determine whether your system is overloaded or cannot handle the amount of subscribers. Typically the load should scale with your active subscriber counts.

Filters

[ day, week ] filters shows the amount of hits on the redirection daemon/pre-portal per minute (aggregrated in longer period reports). It scales quite linearly with your connected devices and can give a indication of the underlying network performance (if there are a lot of connected subscribers yet little redirections/second it could be because requests are lost in transit).

Memory history

[ day, week ] The memory usage graph shows the HSMX memory consumption over time. Memory can have four different states: free, cached, buffer or used. Free memory is not actively used by the operating system, typically HSMX will try to use allocate all memory. Used memory is actively being used by the system, cached memory differs in the sense it is used by the (eg.) database and content filter to cache results in memory but the cache can be released immediately to other processes for consumption (used). Buffers are used to cache read and write operations towards the system storage, it can be an indication of a slow storage subsystem. This can be the case especially on larger sites where subscriber logging is enabled Lawful interception logs, url content filter, …

Leases

[ day, week ] The DHCP lease count over time, the graph depicts the configured IP ranges but ignores static DHCP entries that are configured within that range.

Rooms occupancy

[ day, week ] Displays the number of occupied and vacant rooms over a certain time period. Can be useful to detect PMS connectivity anomalies in the past.

Revenue

[ day, week, month, year ] Revenue is based on the amount of sold packages/packets. Generated vouchers will be instantly counted on that day.

Packets

[ day, week, month, year ] Billing plans can be categorized in payment types (Voucher, PMS, Credit card or Free), this graphical report displays the amount of packets sold on a certain day over a certain period. A voucher counts for the day it was generated on.

Devices

[ day, week, month, year ] This report displays the number of authentications (or started sessions) per device category type over a certain time period.

Volume (per device type)

[ custom configurable range ] Generates a donut-styled chart for received and send data per device category measured at the subscriber networks side (input is traffic towards the HSMX, output traffic towards the subscribers). Proceed to devices to read on how to configure categories.

Webserver

[ day, week, month, year ] The number of threads instantiated to answer every incoming connection. This will be at most the number configured in System > Performance > webserver > Max server processes.

DNS

[ day, week, month ] Displays a graphical representation of the amount of DNS queries for the top 20 most demanded domain names. A table is provided with all the queries and their respective count.

To create one you need to Click on tools → Reports and select the one you want. Then you click on time period and on create.

Active users history

  • Select Active users in the dropdownlist
  • Click on the period that you want to have a report from example a week
  • Select the location/gateway or total
  • Check active and or idle and or pending
  • Click on create report

Room occupancy

  • Select rooms occupancy in the dropdownlist
  • Select the period and click on Create report

Revenue

  • Select Revenue in the dropdownlist
  • Select the period and click on Create report

Examples

Reports

It is possible to generate Microsoft Excel files (.xls) using the report tab. There are three types of reports available: subscribers, bandwidth utilization and revenue. There are many options to generate a report with certain data.

Examples

howto/create-a-report.txt · Last modified: 2015/04/23 09:24 by ewald