TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

USERLOG

DBase Directory Location: GMBASE
Table Description: Log file of user logins, duration and amount of work completed. Displayed in the
GoldMine system logs.

Table Indexes
Name DBase Index SQL Index ID
USERLOG USERID+LOGIN USERID+LOGIN -
ULGRECID RECID RECID -

Table Relationships
Field
None

Table Fields Structure
Field Name Field Type Length Description
CRC String 2 CRC code used as an integrity check to prevent tampering from outside sources.
USERID String 8 User Name
LOGIN String 14 Time logged in (Format YYYYMMDD HH:MM)
LOGOUT String 14 Time logged Out (Format YYYYMMDD HH:MM)
INOUT Integer 2 Number of times user logged in. If more than 1, Track Daily Totals has been turned on for this user.
DUR Long 4 Number of minutes logged in. If Track Daily Totals is turned on, this is the total login time for the day.
KEYS Long 4 Number of keys pressed
CLICKS Long 4 Number of mouse clicks
RECID String 15 Record ID


Your IP Address is: 54.167.44.32