Configure Alarm
LoggingIn order to log alarms to a database you must first define the Tag Alarm Limits as described in Configure Tags of this Quick Start section. You can view the following video to know how to define Alarm Limits if you like.
http://www.opcsystems.com/alarmlimits_video.htm
If you prefer to watch a video on alarm logging use the following link.
http://www.opcsystems.com/alarmloggingfast_video.htm
For a complete list of all Alarm Logging properties refer to the OPC Systems Configuration-Alarm Logging section in this help file.
|
Step |
Task |
|
1 |
|
|
2 |
Select Configure-Alarm Logging.
|
|
3 |
Select the Local OPC Systems Service by selecting the Select button or the Local node in the service tree to the left.
Note The Configure application can be used to connect to remote systems using the network node name or IP address of the remote node the OPC Systems Service is running on. Simply enter the IP Address or network node name of the remote OPC Systems Service you wish to connect to and click on the Select key.
|
|
4 |
Enter the Logging Group Name of Simulation in the field in the upper right.
|
|
5 |
Check Logging Active in the Common Properties Tab.
|
|
6 |
Select the Database Tab.
|
|
7 |
Logging to SQL Server Use the following configuration for SQL Server and SQL Server Express. The Database and Table will automatically be created for you.
The Server name may need to be adjusted from localhost to the proper Server name of the SQL Server engine you wish to log to. This Server name can be found when first bringing up the Connect dialog of the SQL Server Management Studio. Also the login method can be with Windows Authentication or SQL Server mode. Contact your database administrator if you are unsure of what login type to use.
You can download a free version of SQL Server Express from www.microsoft.com. Logging to Oracle If you are using Oracle you must first create the database. All other steps are the same as SQL Server except the provider should be set to Oracle. Logging to mySQL All steps are the same as using SQL Server except the provider should be set to mySQL. Logging to Microsoft Access Use the following configuration for Microsoft Access. The Database and Table will be automatically created for you.
Use the following configuration for CSV text logging. Note: There is no historical replay to alarm windows with CSV logging.
|
|
8 |
Select the Add button to add the Alarm Logging group.
|
|
9 |
Select the Save button on the toolbar at the top.
|
|
10 |
Save the file DemoAlarmLogging.AlarmLog in the directory C:\OPCSystemsDemo.
You can specify for this configuration to load automatically when the Service starts using Configure-Options which is described also in this Training Guide. |
More: