![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211218.webp)
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
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...