Rockwell Automation FactoryTalk View Machine Edition Users Guide - Manual (Page 601)

D-1
A PPENDIX D
ODBC database schema
This appendix describes the ODBC database format, or schema, for messages from
FactoryTalk Diagnostics. The target table of the ODBC database to which you are sending
messages must use the format shown in this appendix.
The option of logging FactoryTalk Diagnostics messages to an ODBC database is
available for personal computers only.
For information about setting up FactoryTalk Diagnostics, see Chapter 10.
FactoryTalk Diagnostics log table
FactoryTalk Diagnostics log data in ODBC format uses one table.
This column Contains SQL data type Length
TimeStmp The time and date data was logged, in coordinated
universal time format. Encoded as a date variant. SQL_TIMESTAMP Driver
dependent
MessageText Message to be logged. SQL_VARCHAR, or
SQL_CHAR 254
Audience A number representing the message audience:
0 for Operator
1 for Engineer
2 for Developer
3 for Secure
SQL_SMALLINT, or
SQL_INTEGER 1
Severity A number representing the severity of the
diagnostics message:
0 for Error
1 for Warning
2 for Information
3 for Audit
SQL_SMALLINT, or
SQL_INTEGER 1
Area The FactoryTalk path to the area in which the
activity occurred. Used for FactoryTalk View Site
Edition only. SQL_VARCHAR, or
SQL_CHAR 80
Location The name of the computer where the message was
generated. SQL_VARCHAR, or
SQL_CHAR 15