Alarm List Detailed

The Alarm List Detailed report lists all alarms for the selected time period in reverse chronological order.

Download link: Alarm List Detailed Report

Dependencies

The Alarm List Detailed report is dependent on the following structures and file:

Database name: Sym3DataStore

Database tables: AlarmLive, DimAlarmPriority, DimAlarmTrigger, DimAlarmTriggerAlarmUDP, DimAlarmUDP, FactAlarm

Stored procedures and functions: fn_SplitString, spr_AlarmDetails

Report file: Alarm Details

Filters

On Start Date/Time:

This filter is used alongside the On End Date/Time filter to display alarms that were activated in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

On End Date/Time:

This filter is used alongside the On Start Date/Time filter to display alarms that were activated in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

Off Start Date/Time:

This filter is used alongside the Off End Date/Time filter to display alarms that were deactivated in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

Off End Date/Time:

This filter is used alongside the Off Start Date/Time filter to display alarms that were deactivated in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

Ack. Start Date/Time:

This filter is used alongside the Ack. End Date/Time filter to display alarms that were acknowledged in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

Ack. End Date/Time:

This filter is used alongside the Ack. Start Date/Time filter to display alarms that were acknowledged in the time period defined by the two filters. Note that this filter is switched off if the “NULL” checkboxes next it is checked.

This filter takes a datetime input in the format of [Day/Month/Year Hour:Minute:Second] but also accepts inputs in the format of [Day/Month/Year], defaulting the time to midnight.

This filter also includes a calendar dropdown which can be used as an alternative method to input the date. Note that using the calendar dropdown only includes the date, and defaults the time to midnight. If the user wants a specific time, this has to be typed in.

Equipment:

This filter is a multi-select dropdown which can be used to select the desired equipment related to an alarm.

Alarm Message:

This filter is used to specify which alarms to display based on the error message input. Note that the input alarm message does not need to be the exact message as the words are used to search in the alarm message.

Priority:

This filter is a multi-select dropdown which can be used to select the desired alarm priority:

• Low: Includes low priority alarms.
• Medium: Includes medium priority alarms.
• High: Includes high priority alarms.
• ALL: Includes all alarms, regardless of their priority.

Data

The report displays all alarms and all the information associated with each one. This includes the time when an alarm was activated, the time when it was deactivated, the time at which it was acknowledged, the user who acknowledged it, the workstation where it was acknowledged, the alarm’s duration, its primary tag name, its priority, the message associated with it, the equipment name, and all user-defined properties (if any).

Name	Description
Alarm Name	Name of the alarm.
On Time	Time when the alarm was activated.
Off Time	Time when the alarm was deactivated.
Ack. Time	Time when the alarm was acknowledged.
Ack. User	The user who acknowledged the alarm.
Ack. Workstations	The workstation where the alarm was acknowledged.
Duration (sec)	Length of time the alarm has been recorded during the selected time period.
Primary Tag Name	Name of the primary tag of the alarm.
Priority	Priority of the alarm.
Message	Alarm message.
Equipment Name	Name of the equipment.

Note: The above table only covers standard alarm details as user-defined properties will vary on a project-by-project basis.