emissary RT: Servers | Page 2

Field	Type	Read-only	Description
ID	Integer	Yes	Primary Key (unique ID) for row
Date	Timestamp	Yes	Date/time the error occurred
Error	Char	Yes	Error description and details
Query	Char	Yes	SQL query that caused the error

Usage Notes

INSERT and DELETE statements may not be run against the 'Errors' table.
The 'Errors' table is automatically purged prior to executing UPDATE, INSERT, or DELETE statements. The table should be checked for error details immediately after an unsuccessful query fails to execute.

Field	Type	Read-only	Description
ID	Integer	Yes	Primary Key (unique ID) for row
Log	Char	Yes	Event log containing event ("Application", "Security", "System", etc)
GeneratedDate	Timestamp	Yes	Date/time event was created
Source	Char	Yes	Application or system that generated event
Level	Char	Yes	Severity Level ("Information", "Warning", "Error", etc)
Message	Char	Yes	Full description of the event
Record	Integer	Yes	Event record number
EventID	Integer	Yes	Event ID
Computer	Char	Yes	Name of the computer generating the event

Usage Notes

'Event' is a read-only table. No UPDATE, INSERT, or DELETE statements may be run against it

Field	Type	Read-only	Description
Key	Char	Yes	Data source setting keyword.
Setting	Char	No	Data source setting value. See notes
Description	Char	Yes	Full description of data source setting

Usage Notes

INSERT and DELETE statements may not be run against the 'Settings' table.
Initial values of the 'Setting' field will reflect data source settings as configured from the ODBC manager.
Changes made to 'Setting' field will immediately update data source settings for the duration of the connection (settings will revert to permanent values upon disconnect). Changes to DHCP, DNS, Events, Server, or Logs will cause emissary RT: Servers to rebuild all caches.

Pages