*Configure Alarm Logging

In 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.

https://www.opcsystems.com/alarmlimits_video.htm

If you prefer to watch a video on alarm logging use the following link.

https://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

Start the Configure OPC Systems application if it is not already running.

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:

Alarm Logging CSV Export and Import

Alarm Logging Programmatic Interface