Selecting 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.

To select the time period of data

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

2. Click the Selection tab.

   

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

4. To use a specific start time and end time, click 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, click 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.

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

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

   • Click 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.

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. Click Apply.