Skip to main content

Data Group

The following describes the historical data group settings specific to the WinCC/PCS7 Alarms connector.

Group Types

image11.png

For WinCC/PCS7 Alarms the following group types are available:

Raw Values

This group retrieves every value logged to the alarm server between the start and end time specified.

Custom Values

This option opens the Database Group builder where a query can be configured to retrieve data from any table available in the database connected to by the connector.

Group Settings

Setup Tab

image12.png

Database

These settings define where the alarm data for group is retrieved.

Table/View

The Table where the alarm data comes from. There are 2 basic tables: AlarmView and AlarmHitView that are available in different languages.

AlarmView which returns individual alarm records and AlarmHitView which returns a summary of alarm information.

Date Column

The column containing the timestamp. For any selected table, the Date Column should be DateTime.

Filters Tab

If the Perform by Server option is checked, any filter configured in this tab is put into the WHERE clause of the query sent to the database to retrieve data for the group. Otherwise, the configured filtering is performed by the reporting engine after the values are returned. It is recommended to leave this setting checked as the performance is much better.

In this section: