Rockwell Automation 9301 Series RSView32 Users Guide - Manual (Page 570)

16–8

RSView32 User’s Guide
Activity log—ODBC format
ODBC format activity log data uses one table. The illustrations show
ODBC tables that have been opened in Microsoft Query. For more
information about how the log files are named, see “The ODBC
storage format” on page 7-8.
This column Contains SQL Data Type Length
Type The number of activity type: 0 for
error, 1 for warning, 2 for information. SQL_SMALLINT
or SQL_INTEGER 2 or
4
Id The number of the RSView32
component that sent the log message
(for RSView32 internal use only). SQL_INTEGER 4
DateAndTime The time and date data was logged. SQL_TIMESTAMP Driver
dependent
Millitm Millisecond time when data was
logged. SQL_SMALLINT
or SQL_INTEGER 2 or
4
DstFlag The Daylight Savings Time (DST) flag,
where 1 means DST is in effect and 0
means DST is not in effect (for
RSView32 internal use only). SQL_VARCHAR
or SQL_CHAR 1
Category The activity category. SQL_VARCHAR
or SQL_CHAR 20
Source The RSView32 component that
generated the activity. SQL_VARCHAR
or SQL_CHAR 20
UserID The user that was logged on when the
activity occurred. SQL_VARCHAR
or SQL_CHAR 20
Dscrptn The description of the activity. SQL_VARCHAR
or SQL_CHAR 132