ODBC table format
The target table of the ODBC database to which you are sending messages must use the format, or schema, shown below. To automatically create a target table with the correct format, select
Create Table
in ODBC Database Destination Setup
If the target table is not in a valid format,
FactoryTalk Diagnostics
will not send any messages to the ODBC data source.Some
FactoryTalk
products make use of additional database fields, however these fields cannot be logged to the ODBC database destination. Even if you create the additional fields in the database, nothing will be logged to them. The additional information logged by a FactoryTalk
product will, however, appear in the Diagnostics Local Log
on the computer on which the product is installed. See documentation for the products you are using to determine whether they make use of additional fields.Field name | Description | SQL data type | Length |
|---|---|---|---|
RecordID | A globally-unique record ID (GUID) to uniquely identify the record. This field is logged as a string value in the format {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}. This field is not shown in the Diagnostics Viewer. | SQL_VARCHAR or SQL_CHAR | 37 |
ParentID | If the message is part of a message chain, the ParentID is the RecordID of the parent message. For messages with no children, this field is 0. This field is logged as a string value in the format {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}. This field is not shown in the Diagnostics Viewer. | SQL_VARCHAR or SQL_CHAR | 37 |
SequenceNumber | If the message is part of a message chain, this field indicates the position of the message in the message chain. The first child in the message chain has a sequence number of 1. For messages with no children, this field is 0. This field is not shown in the Diagnostics Viewer. | SQL_SMALLINT or SQL_INTEGER | |
ChainTime | The earliest timestamp of a message in a message chain. This field is used when reading messages to determine the message order of multiple, interleaved message chains. | SQL_TIMESTAMP | driver dependent |
Timestmp | Timestamp of the record in UTC (coordinated universal time) format. Encoded as a Date variant. | SQL_TIMESTAMP | driver dependent |
MessageText | Message to be logged. | SQL_VARCHAR or SQL_CHAR | 254 Length can be extended to 1999. |
Audience | A number representing the message audience: 8 — Operator 4 — Engineer 2 — Developer | SQL_SMALLINT or SQL_INTEGER | |
Severity | A number representing the message severity: 1 — Error 2 — Warning 4 — Information 8 — Audit | SQL_SMALLINT or SQL_INTEGER | |
Verbosity | A number used to categorize the message further, for example, as a high-level or low-level message. This field is not used by all FactoryTalk -enabled products. Each product can use the integer values to mean different things. For details, see documentation for your FactoryTalk -enabled product. | SQL_SMALLINT or SQL_INTEGER | |
Location | The name of the computer where the message was generated. | SQL_VARCHAR or SQL_CHAR | 15 |
Provider | The name of the product that generated the message. | SQL_VARCHAR SQL_CHAR or | 30 |
UserID | The name of the user performing the action that generated the message. | SQL_VARCHAR SQL_CHAR or | 38 |
UserFullName | The full name of the user performing the action that generated the message. | SQL_VARCHAR or SQL_CHAR | 255 |
Provide Feedback