Reports

HT3 provides you with a variety of reports that allow you to monitor the activity and performance of your telemetry equipment. The reports gather and filter information, based on parameters you provide in the Report Request Form, and present the data in a meaningful and useful form.

Available Reports

The following reports are available:

  • Analog Flow - The Analog Flow report is used specifically for totalizing flow measurements taken in a real-time GPM (gallons per minute) rate. The report provides average GPM and total gallons for the report period as well as the total time the source point's qualifier point was on. The flow signal can come from any type of station (DFS, Modbus, Motorola).
  • Derived Flow - The Derived Flow report calculates the flow at sewage lift stations that aren't equipped with analog flow meters. This report can be generated for any DFS radio or network station with pumps configured.
  • Detail - The Detail Report generates a chronological listing of all events that occurred at the requested telemetry addresses for the specified time period.
  • Force Main - The Force Main report compiles data on the run status of all pumps feeding into a common force main. The report can be used to identify times when pumping efficiency decreases and energy consumption increases because too many pumps that feed into a common force main are running simultaneously. On a system running Data Flow Systems' Symphony Pump and Flow Management, the report can be used to analyze how Symphony is performing and determine if any fine tuning is necessary.
  • Min Max Average - The Min Max Average report is designed for analyzing analog data such as pressure and flow measurements, chlorine residuals, turbidity, and tank levels. The Min Max Average report lists daily minimum, maximum and average values recorded during the selected time span for each point included in the report.
  • Pulse - The Pulse report provides daily pulse count totals for equipment (e.g., rain gauge or flow meter) that provides a pulse signal that represents a specific amount.
  • Pump Activity - The Pump Activity report provides data on the activity of a digital point. This report is typically used to calculate run times and monitor behavior of pumps and wells, but it can be used for any digital point. The report provides the minimum length of time the point was on; the maximum length of time the point was on; the average length of time the points was on; the total number of times the point came on.
  • Snapshot - The Snapshot report is designed for analyzing analog data such as water plant turbidity measurements and chlorine and PH levels. For the selected time span, the Snapshot report returns values in 15 minute intervals for each point included in the report. The value returned is the last value recorded for the point prior to the interval.

Creating a Report

HT3's simple reporting interface makes it easy to create a report.

In addition to the reports listed above, HT3 features several pre-formatted reports:

  • Comment Log - The Comment Log is an electronic journal of events that affect your utility's operation. You can record significant events that aren't logged elsewhere in the system. For example, you can note a heavy period of rainfall or explain that a pump's extended run time was the result of the mechanical failure of a backup pump. When necessary, this information can be easily retrieved using queries based on dates.
  • Digipeat Map - The Digipeat Map lists all DFS stations that are digipeating and provides their relay paths. Information on digipeating can be found in Configuring a Station to Digipeat.
  • Modbus Map - The Modbus Map lists information on each DFS point that is emulating Modbus. Modbus emulation enables the Hyper SCADA Server (HSS) to respond as a Modbus TCP client by allowing DFS-type points to be queried as registers via the Modbus TCP protocol.
  • Station Configuration - The Station Configuration report lists the selected station's settings, including its partition, polling priority, volume, each module configured at the station, and the module's associated I/O points.

An Advanced Reporting Tool is available for creating access, alarm and control logs and radio error reports, and using advanced features to create analog flow, derived flow, detail, pulse, and pump activity reports.

Report Output

The image below shows a portion of the report generated by the report form shown above. This example shows a Pump Activity report that was run on the keyword "PUMPLS" on March 15, 2011.

For each date and point included in the report, the report shows the minimum on time, maximum on time, total on time, average on time, and the number of times the point came on. The report is organized by date and then by telemetry address. The last section of the report provides data totals for the report's date and time span.

The Station Names and Point Names are links that open charts for the corresponding data. Additionally, if you mouse over a point, a line chart of the point's activity pops up on the screen.

Pie, Bar and Line Charts

Pie, bar, and line charts are available from HTML-formatted reports. Charts are helpful for analyzing data, because they give you a visual representation of the data that is quickly understood.

The example below shows a Pump Activity Report for all points assigned to the keyword "PUMPLS." If we click a station name (for example, Symphony TCU 11 in the screenshots above), a new window would open with:

  • Pie charts showing the total runtime and total starts for each the points.
  • Bar chart of the minimum, average, and maximum run times for each of the points.
  • Line chart of the point's on and off activity.

Pie Chart

Bar Chart

Line Chart

Purge Schedules

The data stored in HT3's journals and logs is maintained in the active system for a limited period of time. After this time, it is moved to an archive in order to optimize hard drive space and system communication time.

  • Journals - Archived after 1 year; a Journal is created for each 24 hour period beginning at midnight. Journals contain all system data except for that stored in HT3's Logs.
  • Access Log - Archived after 1 year
  • Comment Log - Archived after 1 year
  • Alarm Log - Archived after 6 months
  • Control Log - Archived after 3 months
  • Radio Error Log - Archived after 14 days