Omron CX-Supervisor - Page 12

11
12-10-2 Compound Relation Hierarchy example: ............................................................................198
12-10-3 Hierarchy with Aggregate example:....................................................................................198
12-10-4 Group Hierarchy example: .................................................................................................198
12-10-5 Group Hierarchy with Aggregate example: ........................................................................198
12-10-6 Multiple Groupings example: .............................................................................................199
12-10-7 Grand Total example: .........................................................................................................199
12-10-8 Grouped Parent Related to Grouped Child example: ........................................................199
SECTION 13
CFR (Title 21 Part 11) Functionality ........................................201
13-1 Overview ..........................................................................................................................................201
13-2 Supported Databases ......................................................................................................................201
13-3 CX-Supervisor Runtime User and Audit Trail UserID ......................................................................201
13-4 Creating / Running a CFR Application (Microsoft Access)...............................................................202
13-4-1 CFR Test Application..........................................................................................................202
13-4-2 Configuring Points for Audit ................................................................................................203
13-4-3 Default Audit Trail Configuration.........................................................................................203
13-4-4 Default Connection String...................................................................................................204
13-4-5 Logged In User ...................................................................................................................205
13-4-6 Starting and Stopping an Audit Trail ...................................................................................205
13-4-7 Running the CFR Test Application and Logging to an Access Database...........................205
13-4-8 Viewing the Audit Trail Database........................................................................................206
13-4-9 Audit Trail Configuration Settings – Alarms Errors and Events ..........................................207
13-4-10 Configuring Alarms for Audit Trail Records.........................................................................207
13-4-11 Generating Errors and Events in Audit Trail Records.........................................................209
13-4-12 Running the CFR Test Application to Generate Alarm Error and Event Records...............209
13-4-13 Viewing the Alarm Error and Events Data Tables...............................................................210
13-5 Logging Audit Trails to an SQL Database........................................................................................210
13-5-1 SQL Server Database Prerequisites...................................................................................211
13-5-2 Creating an SQL Server Test Project .................................................................................211
13-5-3 Connection String for an SQL Database.............................................................................212
13-5-4 Running an SQL Server Test Project..................................................................................213
13-5-5 Viewing Audit Trail Records in an SQL Server Test Project...............................................213
13-6 Further Settings and Configuration ..................................................................................................213
13-6-1 Database File Location .......................................................................................................214
13-6-2 Microsoft Access Database File Management....................................................................214
13-6-3 Audit Trail Notes .................................................................................................................215
13-6-4 SQL Statements..................................................................................................................216
13-7 How to Access Information from a CFR Database ..........................................................................217
13-7-1 Using CX-Supervisor ..........................................................................................................217
13-7-2 Using Microsoft Excel .........................................................................................................218
13-8 Limitations........................................................................................................................................221
SECTION 14
Standard Web Pages ...................................................................223
14-1 Overview ..........................................................................................................................................223
14-2 Access..............................................................................................................................................223