TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

SYSLOG

DBase Directory Location: GMBASE
Table Description: System log, contains details about database maintenance and other database-related activities.

Table Indexes
Name DBase Index SQL Index ID
SYSDATE RECTYPE+DTOS(ONDATE)+ONTIME RECTYPE+ONDATE+ONTIME -
SYSPID RECTYPE+PID+DTOS(ONDATE)+ONTIME RECTYPE+PID+ONDATE+ONTIME -
SYSSITEID RECTYPE+SITEID+DTOS(ONDATE)+ONTIME RECTYPE+SITEID+ONDATE+ONTIME -
SYSRECID RECID RECID -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
RECTYPE String 1 Record Type. Possible values are listed below.
Value Description
E Error
G Gold Sync
M Maintenance Task
P Process Monitor Window
W Sync Wizard
PID String 33 Process ID
SITEID String 20 Site ID - Contains the Site ID the entry relates to
ONDATE Date 8 Date of entry (m/d/yy)
ONTIME String 5 Time of entry (hh:mm)
RESULTCODE String 3 Type of message (i.e. ERR)
USERID String 8 User logged in at time of message
REF String 50 Typically first line or primary message
PARAMS Memo - Full text of the message
RECID String 15 Record ID

Your IP Address is: 54.167.44.32