MonitorWare Agent 4.x – Database Structure

Created 2003-05-05 by Wajih-ur-Rehman.
Last Updated 2006-06-21 by Timm Herget.

What is the new Database Structure for MonitorWare Agent 4.x?

The Database Structure for MonitorWare Agent 4.x is almost the same as that of the older versions with the exception of SystemEventsProperties Table which is new in this new Database schema. In this new version, what the agent does is that it parses the message field and takes out some known parameters and store them in the form of name value pairs in the SystemEventsProperties Table as a Foreign Key. This means that one row in the SystemEvents Table can have multiples entries (in the form of name value pairs) in the SystemEventsProperties Table.