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

Sharing data with other Windows applications

16–11
Alarm log files—ODBC format
ODBC format alarm 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.
UserStn For future use.
LoggingStn The name of the computer on which the logging server is
running.
This column Contains
This column Contains SQL Data Type Length
DateAndTime The time and date the alarm was
generated. SQL_TIMESTAMP Driver
dependent
Millitm The millisecond time when the alarm
transaction was generated. SQL_SMALLINT
or SQL_INTEGER 2 or
4
TransType The type of alarm that was generated. SQL_VARCHAR
or SQL_CHAR 5
TagName The name of the tag or alarm event
that caused the alarm. SQL_VARCHAR
or SQL_CHAR 255
TagValue The value of the tag at the time the
alarm occurred. SQL_DOUBLE or
SQL_INTEGER or
SQL_SMALLINT 8 or
4 or
2