The PingLog table will contain an entry for each detected state transition (ON to OFF or viceversa) for each monitored machine during a monitored period of time. The log tableĬONSTRAINT PRIMARY KEY CLUSTERED (Host ASC, Status ASC, The user interface provided by the PingMonitor application allows you to visually edit the tree while directly modifying the underlying HostList table (please, notice that the deletion of nodes and the addition of children nodes is allowed through the context menu on the tree). For each machine, it stores: the machine name with a unique ID ( Host and ID fields), the frenquency of monitoring ( PingFreq field, expressed in seconds), a flag indicating if the monitoring is currently activated ( DoPing field) and a flag indicating if the specific machine has to be shown in the UI ( ShowInMonitor field).īeing able to list a hierarchycal tree enables you to organize the machines to be monitored in groups and subgroups, the HostList table supports the concept of parent-child node relationships (via the IDparent field) and the concept of "folder" tree nodes, that are intermediate nodes not corresponding to an host but simply being the parent of other nodes (for them, the IsHost flag is not set to "yes"). The HostList table will contain the list of the machines to be monitored. WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON PRIMARY
The configuration tableĬONSTRAINT PK_HostList PRIMARY KEY CLUSTERED (ID ASC) The following are the two table schemas, expressed in T-SQL code, with some explanations. I decided to use a SQL Server 2000 (or 2005) database to host both the configuration (that is, a list of machines to be monitored) and the log.
#Quick ping monitor serial key windows
Other than a Windows Service for the monitoring and a database as a storage, we obviously need also a user interface (UI) to interact with the configuration and the log that's why I created a simple Windows Form application (named PingMonitor) to accomplish these tasks: showing the last PING status of the monitored machines and editing the PingMonitorService configuration.
#Quick ping monitor serial key code
Download source code (C# version) - 28 KB.Download source code (VB.NET version) - 36 KB.