Select the time period of data from the alarm database

You can set query values to select records based on the selected time. You can also configure the maximum number of records to view, the start and end time of the alarm query, and the query time zone.

The number of records retrieved by an alarm database query affects the time required to show the records in the Alarm DB View control. The Alarm DB View control takes approximately 30 seconds to show 50000 records retrieved from the alarm database.

To improve the performance of the Alarm DB View control, reduce the Maximum Records value to display records more quickly. Also, you can select a shorter record retrieval interval in the Duration field to improve the performance of the Alarm DB View control.

Select the time period of data

1. Right-click the Alarm DB View control and then select Properties. The AlmDBViewCtrl Properties dialog box appears.

2. Select the Selection tab.

   

3. To use a pre-defined time interval that always queries for data using the UTC time zone, select an interval from the Duration list.

4. To use a specific start time and end time, select Use Specific Time and then configure the details.

   1. In the Start Time box, enter the start time to retrieve the alarm records. The string must be in MM/DD/YYYY HH:MM:SS format. Use any date in any time zone from midnight, January 1, 1970, to January 18, 19:14:07, 2038.

   2. In the End Time box, enter the end time to stop retrieving alarm records. The string must be in MM/DD/YYYY HH:MM:SS format. Use any date in any time zone from midnight, January 1, 1970, to January 18, 19:14:07, 2038.

   3. In the Query Time Zone area, select either UTC or Origin Time. UTC time is Greenwich Mean Time, also known as Coordinated Universal Time or Zulu. Origin time is the current time in the operator’s time zone. For more information refer to Query Time Zones topic.

5. In the Duration Column area, configure which type of duration is shown. Duration is measured in milliseconds.

   • Select UnAck Duration to show the time between the most recent alarm transition (alarm or sub-state) and the acknowledgement, if any.

   • Select Alarm Duration to show the amount of time elapsed between the initial occurrence of an alarm and the time at which it returned to a normal state.

     For more information on the calculation of UnAck Duration and Alarm Duration for LATCHED state refer to Alarm Duration and UNACK Duration for LATCHED Alarms topic.

6. In the Maximum Records box, type the number of records to view from the control at one instance. The valid range of maximum records is from 1 to 1000.

7. Select Apply.