App Store Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Alarm Analysis Event Sink ======

**Alarm Analysis Event Sink** is a data core target object. When connected to a data core event source,  event messages are transformed into **AA event messages** and saved to **Alarm Analysis**. The point of the AA event message structure is to facilitate big data number crunching that can reveal all sorts of useful information from your Alarm & Event log.

Data transformation includes:

  * Field Mapping.
  * Value overrides: Set a field to an explicit value. For example, "Plant Name".
  * Value Mapping: For example, "ALARM_1_RTN", "RETURNTONORMAL", "EVENTRETURN", "NORMAL" all get mapped to to "RTN".
  * Data Correction.
  * De-duplication.
  * Data Enrichment: Alarm duration calculated, meta tags identified (e.g. Tag Alm Count), etc...


== Configuring the AA Event Sink ==

The **Event Field Mapping** section of the Event Sink exposes AA Event Message fields that can be set.

Examples:

In the following examples, we're setting the Alarm Analysis "Event Type" mapping.


1. Map a source data core event property called "AlarmAction" to the AA "Event Type" field

<code> [[AlarmAction]] </code>

The double square brackets indicate we're referencing the event-source property collection for a property named "AlarmAction".

2. Value Override

Set event-type to ALM in all cases

<code> "ALM" </code>

Quote marks indicate this is a text value (rather than a field).

3. Logic

The mapping supports logic using a c#-style syntax in conjunction with "double bracket" field selectors.

For a single statement, the mapping will infer that the result is to be used directly.

//Example://

Map the value from "AlarmAction" event source field converted to upper-case.

<code>

((string)[[AlarmAction]]).ToUpper()

</code>

For more complex multi-line statements, semi-colon statement terminators must be used and an explicit value returned.

//Example://

If the source data "AlarmAction" field is empty, set the AA Event Type value to "EVT"

<code>

var alarmAction = (string)[[AlarmAction]];
if (string.IsNullOrEmpty(alarmAction))
{
  return "EVT";
}
return alarmAction;

</code>


4. Default Mappings

The following default mappings are applied.

<code>
msg.Id = srcEvent.ID;
msg.TimeStamp = srcEvent.UtcEventTime;
msg.EventType = "EVT";
msg.Tag = "Undefined";
msg.MessageDescription = srcEvent.Message;
</code>

These defaults are the minimum requirements to import a "valid" record, but it may not be accurate. The referenced source event fields belong to the Data Core data container and not the true source data.

=== Advanced Settings ===

An administrator can prepare a C# code file to perform data transformation, but it is a highly technical task that requires full understanding the the underlying data objects. We recommend Intelligent Plant assist with this activity.

The default location for Script Files is in the 
  <Data Core Application Root folder>/ImportScripts

To use an alternative location, define the <code>dataCore:alarmAnalysis:baseDirectory</code> setting as per [[data_core:update_safe_configuration|"update-safe" configuration]] guidance.