Omron CX-Supervisor - How to Access Information from a CFR Database; Using CX-Supervisor

How to Access Information from a CFR Database SECTION 13 CFR (Title 21 Part 11)
217
The following SQL statements create the tables required for Audit Trail
logging.
Points Table
CREATE TABLE [dbo].[Points]
( [PointId] int IDENTITY NOT NULL PRIMARY KEY, [Date] varchar(15) NOT
NULL, [Time] varchar(10) NOT NULL, [Name] varchar(50) NOT NULL, [Index]
int NOT NULL, [PreviousValue] varchar(250) NOT NULL, [NewValue]
varchar(250) NOT NULL, [UserId] varchar(250) NOT NULL,
[AuditId] varchar(250) NULL, [AuditNote] varchar(250) NULL )
Alarms Table
CREATE TABLE [dbo].[Alarms]
( [AlarmId] int IDENTITY NOT NULL PRIMARY KEY, [Date] varchar(15) NOT
NULL, [Time] varchar(10) NOT NULL, [Name] varchar(50) NOT NULL,
[Priority] varchar(15) NOT NULL, [PreviousState] varchar(20) NOT NULL,
[NewState] varchar(20) NOT NULL, [UserId] varchar(250) NOT NULL,
[AuditId] varchar(250) NULL, [AuditNote] varchar(250) NULL )
Events Table
CREATE TABLE [dbo].[Events]
( [EventId] int IDENTITY NOT NULL PRIMARY KEY, [Date] varchar(15) NOT
NULL, [Time] varchar(10) NOT NULL, [Message] varchar(250) NOT NULL,
[UserId] varchar(250) NOT NULL, [AuditId] varchar(250) NULL, [AuditNote]
varchar(250) NULL )
Errors Table
CREATE TABLE [dbo].[Errors]
( [ErrorId] int IDENTITY NOT NULL PRIMARY KEY, [Date] varchar(15) NOT
NULL, [Time] varchar(10) NOT NULL, [Priority] varchar(10) NOT NULL,
[Message] varchar(250) NOT NULL, [UserId] varchar(250) NOT NULL,
[AuditId] varchar(250) NULL, [AuditNote] varchar(250) NULL )
13-7 How to Access Information from a CFR Database
The following sections provide instructions on how to read the information
from a CFR database that was generated by CX-Supervisor.
13-7-1 Using CX-Supervisor
When configuring the ‘Data Source’ information in the ‘Add Connection’
dialog, the following ‘Connection String’ is required to connect to the password
protected CFR database files.
Connection String Format
Driver={Microsoft Access Driver (*.mdb)};
DBQ=<project folder>\AuditTrail\<database filename(.mdb)>;
SystemDB=<project folder>\<system database(.mdw)>;
Uid=Guest;
The first two lines of the connection string are generated by default. The
following two lines must be added by the user. A path must be given to the
System Database file ‘CXSupervisorAudit.mdw’, which is located in the