CTS Daily Alarm Report

⚙Robotic Process Automation

A C# WinForms desktop application backed by a PowerShell engine that generates comprehensive daily CTS alarm reports. Combines HST alarm history, DBF transaction data, device configuration, and zone mapping to produce a unified HTML email report. Identifies alarm patterns by device and zone, tracks technician diagnostic sessions by shift, highlights the longest transactions, detects zone goosing events, and summarizes network communication health.

Technology Stack

C#.NET Framework 4.0Windows FormsPowerShellGmail SMTPHST ParsingDBF Parsing

System Architecture

Loading diagram...

Specifications

▸Multi-Source Parsing: Combines HST history file and DBF transaction records (201, 202, 203, 301) into a unified view
▸Zone Hierarchy Mapping: Traces each device through the equipment hierarchy to PV zones (1-23, 125, 555)
▸Technician Identification: Maps diagnostic sessions to technicians by shift: Basil (00-08), Sean (08-16), Mohammed (16-24)
▸Alarm Breakdown: Alarms grouped by device with AM/PM timestamps and severity color coding
▸Top Devices & Transactions: Highlights top 10 most active devices and top 15 longest transactions
▸Auto-Cleared Alarms: Tracks comm failures and destination-full alarms that resolved automatically
▸Zone Goosing Detection: Identifies quick zone reset events that may indicate recurring issues
▸Network Health Summary: Communication health analysis across the entire CTS network

Design Decisions

Challenge	Solution
HST and DBF use different record formats	Dedicated parsers for each format with record-type routing (201/202/203/301)
TCU alarms need special routing	Logic to map TCU alarms to correct TCU (125 or 555) based on zone hierarchy
Identifying who was on shift	Time-based technician mapping using 8-hour shift boundaries
Report needs to be scannable at a glance	HTML email with summary stats header, color-coded sections, and ranked tables
Quick date selection for common cases	Today checkbox and Yesterday button for one-click date selection

Process Flow

Loading diagram...