Top 10 Alarms (Occurrence)

The Top 10 Alarms (Occurrence) report lists the top 10 alarms by count of occurrences for the selected time period.

Download link: Top 10 Alarms (Occurrence) Report

Dependencies

The Top 10 Alarms (Occurrence) report is dependent on the following structures and file:

Database name: Sym3DataStore

Database tables: AlarmLive, DimAlarmTrigger, FactAlarm

Stored procedures and functions: spr_Alarm_T10_Occurrence

Report file: Top 10 Alarms (Occurrence)

Filters

Start Date/Time:

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.

End Date/Time:

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.

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 the top 10 alarms based on their occurrence, with the relevant equipment and message associated with it.

Name	Description
Alarm Name	Name of the alarm.
Equipment Name	Name of the equipment.
Message	Alarm message.
Occurrences	Number of times the alarm has been recorded during the selected time period.