Logging

This screen lets you specify options regarding Overseer's logging

Check History Days: This is a setting that controls how long Overseer keeps data in its internal database detailing when each resource was checked, the status, and any error message or data value.
No External Logging: This is the option to disable external logging by Overseer. This is the default, as external logging is not required by most users.
Log to text file: This option lets you specify a text file that Overseer logs to. Note that the NETWORK SERVICE user needs full control permissions to this file. This file will be created automatically if the NETWORK SERVICE user has access to the containing directory, but must be created manually otherwise.
Log to ODBC Data Source: This option lets you specify ODBC logging of Overseer events. Specify the DSN name in the text box below this label. See the notes section for details on setting up the database.
Username: This is the username for the DSN specified above.
Password: This is the password for the DSN specified above.
Log Success: Checking this instructs Overseer to create a log entry in the text file or ODBC data source, each time Overseer checks the resource and it is online.
Log Failures: Checking this instructs Overseer to create a log entry in the text file or ODBC data source, each time Overseer checks the resource and it is offline.
Log Recovery: Checking this instructs Overseer to create a log entry in the text file or ODBC data source, each time Overseer checks the resource and it is online, but was just previously offline(resource recovers from failure).

Note: ODBC DSN's must be setup in the Windows control panel as a "System DSN" and not a "User DSN". The ODBC data source should have a table named "OverseerLog" with the following fields:

iResourceType(Integer) - This stores the resource type(1=HTTP, 2=Ping, 3=Service, 4=Event Log, 5=Disk Space, 6=EM1 Sensor, 7=Process Monitor, 8=Database Query)

cResourceName(varchar(200)) - This stores the name of the resource.

tDateTime(datetime) - This stores the date/time of the event.

bSuccess(bit) - This stores the success/failure of the event(1=success, 0=failure)

mErrorMessage(mErrorMessage) - This stores the error message for the event

MSSQL Create Table Command:

CREATE TABLE OverseerLog (iResourceType int, cResourceName varchar(200), tDateTime datetime, bSuccess bit, mErrorMessage text);