FlexLink YOUTILIZE - Manual (Page 101)

Providing production efficiency
Page 101 of 125
Sample SQL Statements
In Fusion Server Manager enable SQL logging to determine problems with generated SQL
statements.
1. Fusion Server Manager – Diagnostics – System Logging: Select SQL add the required service:
2. AegisRealTimeAnalysisServer.exe, xLinkTransmitter.exe or iMonitorExpress.exe
3. Check all Output Levels
4. Set a log File directory and other applicable miscellaneous settings.
5. Select the formatting tab
6. Change the Output type for SQL to Simple text and select all the Auto fields.
7. Apply the changes and restart the services.
8. Log file should appear in the folder which will contain SQL statements run against the SQL
Server.
Matrikon OPC Server
Verifying PLC Information via Matrikon OPC Server
Open the Matrikon OPC Explorer by selecting it from start menu. Start Æ MatrikonOPC Æ Explorer
Æ and select ‘MatrikonOPC Explorer’.