emissary RT: Servers

Support Knowledgebase

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

  1. INSERT and DELETE statements may not be run against the 'Errors' table.
  2. 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

  1. '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

  1. INSERT and DELETE statements may not be run against the 'Settings' table.
  2. Initial values of the 'Setting' field will reflect data source settings as configured from the ODBC manager.
  3. 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

© 2022 Synthetic Dreams LLC Back to Top

Back to Top

Follow Us

Twitter icon
Facebook icon
LinkedIn icon

Tweets from the Team